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

What is pivot in sql?

973

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1185

What are the ways on commenting in a pl/sql code?

1206

Is grant a ddl statement?

945

Why query optimization is needed?

975

define join and explain different type of joins? : Sql dba

1002

What is sql server and ase?

1072

Why partition by is used in sql?

1083

What are the various restrictions imposed on view in terms of dml?

1017

What is sqlite format?

1265

What is cost in sql execution plan?

1045

What is delete command in sql?

1174

Define concurrency control. : Transact sql

1236

Why coalesce is used in sql?

1069

what is a field in a database ? : Sql dba

1099