Home » SQL & PL/SQL » SQL & PL/SQL » comparision with data type LONG
comparision with data type LONG [message #20697] Fri, 14 June 2002 07:12 Go to next message
marek
Messages: 1
Registered: June 2002
Junior Member
i have a query of this type:

select field_1, field_2
from table1
where field_2 != 0;

the data type of 'field_2' is LONG.
When I exequte the query on SQL Plus I got an error message of this type: "UNCORRECT USE OF DATA TYPE LONG" ????? I gess i should make the comparision with the long type in a different way....Which??? Thanks in advance. Marek.
Re: comparision with data type LONG [message #20713 is a reply to message #20697] Fri, 14 June 2002 18:53 Go to previous message
Su
Messages: 154
Registered: April 2002
Senior Member
As per my knowledge and I remember, the ORACLE does not allow the usage of a LONG type column in subqueries, functions, expressions, where clauses or indexes. And a table can not have more than one LONG type column and it can not be clustered. Check it out.
Previous Topic: Running multiple procedures from one script file
Next Topic: Partitioning Howto, at Standard Edition?
Goto Forum:
  


Current Time: Thu Mar 28 06:18:37 CDT 2024