New answers tagged

0

Something, somewhere is doing an implicit conversion. Since int has a higher precedence than varchar the string "www.com" is being cast to int and failing. First try a simple select * from view_a. Does that succeed? If it does it suggest table1 and table2 have compatible data types in their corresponding columns. Second check the types assigned to ...


0

Slightly rewritten (so that number of rows is fetched out of the cursor): SQL> create or replace procedure find_table_with_column_value 2 (arg_column_name in varchar2, arg_column_value in varchar2) 3 is 4 v_rowcount number; 5 v_sql_statement varchar2(4000); 6 begin 7 for l in (select owner || '.' || table_name as owner_table ...


1

Specifying a value after INT (e.g. INT(8)) does nothing in MySQL apart from affecting the ZEROFILL option. From here (the poster has ~ 500K rep. on StackOverflow and was MySQL Community Manager, so he probably knows what he's talking about): The 20 in INT(20) and BIGINT(20) means almost nothing. It's a hint for display width. It has nothing to do with ...


Top 50 recent answers are included