while using where or order by clause in long datatype column . error will

Is it possible to use LONG columns in WHERE clause or ORDER
BY?

Question Posted / lakshmikanthan

3 Answers
16720 Views
I also Faced
E-Mail Answers

Answer Posted / lakshmikanthan

while using where or order by clause in long datatype column . error will come LIKE
ORA-00997: illegal use of LONG datatype .

And another points is :
1. only one long data type allowed in a table
2. cannot able to create the constraint in a long data type column in a table
error :
ORA-02269: key column cannot be of LONG datatype.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can a table contain multiple primary key’s?

1042

What are different types of functions in sql?

955

What is the usage of the distinct keyword?

1166

Is sql free?

887

Does normalization improve performance?

980

What is pl/sql table? Why is it used?

977

Is sql pronounced sequel or sql?

1213

how to get a list of columns in an existing table? : Sql dba

914

What is an invalid partition table?

959

What is a left inner join?

946

Why stored procedures are faster than query?

969

What jobs use sql?

925

how to run 'mysql' commands from a batch file? : Sql dba

1061

how to enter characters as hex numbers? : Sql dba

993

What are the benefits of pl/sql packages?

1033