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
16904 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

how do you know the version of your mysql server? : Sql dba

1004

What is delimiter sql?

1008

What mean sql?

1014

What is native sql query?

1025

What is sqlexception in java?

994

What is the current version of sql?

1023

what is primary key? : Sql dba

1029

What is thread join () in threading?

1016

What is row_number () in sql?

984

How can you save or place your msg in a table?

1002

What are the two types of exceptions in pl/sql?

1052

What is the max nvarchar size?

982

Name three sql operations that perform a sort.

1014

Can you have more than one key in a database?

937

Which table is left in join?

979