New answers tagged errors
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 ...
-2
Save your data to a CSV file, import to a table, and then join.
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