Interested to Buy Any Domain ? << Click Here >> for more details...
How many LONG columns are allowed in a table?
- 6 Answers
- 24666 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How do I run a pl sql procedure in sql developer?
What is mutating trigger?
Is full outer join same as cross join?
how can we repair a mysql table? : Sql dba
Does oracle roll back the transaction on an error?
explain access control lists. : Sql dba
How do I start sql from command line?
How do you drop a trigger?
what is a cursor? : Sql dba
How many triggers can be applied to a table?
Is drop table faster than truncate?
Is big data nosql?
How much does sql certification cost?
What is string data type in sql?
what is uncommittable transactions? : Transact sql
