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

Mention what pl/sql package consists of?

980

Is sql workbench free?

973

what are the different tables present in mysql? : Sql dba

958

What is a dirty read sql?

1109

what is the difference between a local and a global temporary table? : Sql dba

1046

define sql update statement ? : Sql dba

1100

What is a ddl command?

1069

Can we join 3 tables in sql?

1004

Can you have a foreign key without a primary key?

938

Does sql between include endpoints?

989

What is scalar and vector?

987

How do I make sql search faster?

982

Explain the methods used to protect source code of pl/sql.

1007

In a distributed database system, can we execute two queries simultaneously?

1060

what is transaction? : Sql dba

992