-
SQL Query Error - LONG datatype
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?
-
RE:SQL Query Error - LONG datatype
Thanks for the quick reply.
Test is a LONG data type field.
-
-
No, it is not a numeric data type.
-
-
Oracle 9i is the rdbms I use.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|