I am using this sql query below to bring back results based upon LONG field.
"select test from all_data where test like 'AC%';"
"ERROR at line 1: ORA-00932: inconsistent datatypes "
Is there a way to accomplish this?
Printable View
I am using this sql query below to bring back results based upon LONG field.
"select test from all_data where test like 'AC%';"
"ERROR at line 1: ORA-00932: inconsistent datatypes "
Is there a way to accomplish this?
What's data type of test column?
Thanks for the quick reply.
Test is a LONG data type field.
Is it numeric data type?
No, it is not a numeric data type.
Which rdbms do you use?
Oracle 9i is the rdbms I use.