Is it possible to use LONG columns in WHERE clause or ORDER
BY?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Long data type can't participate for any operation in SQL.
Only DML queries can be applied.
Can't apply any aggregate function on LONG colum.
Can't apply any analytical function on LONG colum.
Can apply sequence on LONG colum.
Can apply synonym for LONG column table.
Can create view for LONG column table and Mat view is not possible.
Is This Answer Correct ? | 0 Yes | 0 No |
What is sql engine in oracle?
What plvcmt and plvrb does in pl/sql?
What has stored procedures in sql and how we can use it?
we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?
If a cursor is open, how can we find in a pl/sql block?
How to Declare Fixed Length String Value In PL SQL
Can we write dml inside a function in sql server?
Do prepared statements prevent sql injection?
what is the use of set statement in tsql? : Transact sql
Store procedure will return a value?
how to get the third quarter of employee details from emp?
How to set up sql*plus output format in oracle?