comparision with data type LONG [message #20697] |
Fri, 14 June 2002 07:12 |
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 |
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.
|
|
|