Results 1 to 7 of 7

Thread: SQL Query Error - LONG datatype

  1. #1
    Join Date
    Oct 2007
    Posts
    10

    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?

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    What's data type of test column?

  3. #3
    Join Date
    Oct 2007
    Posts
    10

    RE:SQL Query Error - LONG datatype

    Thanks for the quick reply.

    Test is a LONG data type field.

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Is it numeric data type?

  5. #5
    Join Date
    Oct 2007
    Posts
    10
    No, it is not a numeric data type.

  6. #6
    Join Date
    Sep 2002
    Posts
    5,938
    Which rdbms do you use?

  7. #7
    Join Date
    Oct 2007
    Posts
    10
    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
  •