Interested to Buy Any Domain ? << Click Here >> for more details...
How many LONG columns are allowed in a table?
- 6 Answers
- 24373 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
What is character functions?
What is trigger and stored procedure in sql?
What is the difference between nvl function, ifnull function, and isnull function?
I need a function for a train ticket reservation please answer it thanks in advance
Is sql open source?
What is dynamic query?
What is sql lookup?
Explain table and field in sql?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
What is trigger price?
How do I view stored procedures?
What is a field in a database?
what is a unique key ? : Sql dba
Why is sql*loader direct path so fast?
Explain the types of joins in sql?
