Is it possible to use LONG columns in WHERE clause or ORDER
BY?
Answer Posted / pavan_1981
no its not possible to use long columns in WHERE or ORDERBY
clause.other restrictios on LONG column are
1.there can be only colum of long data type in a table.
2.no constraints can be defined on long column.
3.a long column will not be cpied when u create a new table
from existing table using a subquery.
| Is This Answer Correct ? | 21 Yes | 4 No |
Post New Answer View All Answers
What are the two types of exceptions.
Does google use sql?
What is the clause we need to add in function body to return variable?
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
How to start the command-line sql*plus?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
Why do we use partitions in sql?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
Which is faster truncate or drop?
What is primary key sql?
What is sql engine in oracle?
What is string data type in sql?
what is recursive stored procedure? : Sql dba
How would you convert date into julian date format?