How many LONG columns are allowed in a table?
Answers were Sorted based on User's Feedback
Answer / harshit varshney
Only one column can have LONG data type. And that column cannot be used in WHERE clause or in ORDER BY clause. Also we cannot add primary key constraint to that column only not to the whole table, that means we will give primary key to any column in the table except the column having the long data type. If we give, we get the error ORA-02269: key column cannot be of LONG datatype.
Is This Answer Correct ? | 4 Yes | 0 No |
display your age in months?
How do you declare a variable in pl sql?
What is sql dialect?
What is oracle sql called?
What is the difference between DELETE and TRUNCATE?
15 Answers Johns Hopkins University, Tech Mahindra,
What are tables and fields in the database?
What is error ora-12154: tns:could not resolve the connect identifier specified?
how to select unique records from a table? : Sql dba
what are the drivers in mysql? : Sql dba
What is int identity in sql?
Explain what is a view?
What is an emotional trigger?