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
16877 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 many joins can you have in sql?

930

What is sql dialect?

1108

How do you create a unique index?

1044

What are the types of variables use in pl sql?

1037

Is ms sql traffic encrypted?

916

How do you get column names only for a table (sql server)?

1151

How can I speed up sql query?

957

How can we avoid duplicating records in a query?

974

Which is the correct statement about truncate and delete?

1104

How long it takes to learn pl sql?

1005

How to run pl sql program in mysql?

1012

How do I run a sql query in pgadmin 4?

958

what is 'mysqladmin' in mysql? : Sql dba

1024

Can we use two order by clause in query?

959

Explain commit, rollback and savepoint.

990