How many LONG columns are allowed in a table?
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
Which nosql database is best?
What packages are available to pl/sql developers?
Why indexing is needed?
Is sql a backend?
Is it possible to read/write files to-and-from PL/SQL?
how many sql dml commands are supported by 'mysql'? : Sql dba
What is the maximum rows in csv?
Is sql free?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
How many commands are there in sql?
Who developed sql?
Which query operators in sql is used for pattern matching?
What is a scalar value in sql?
What is the difference between an inner and outer join?
What is the difference between Union and Union all. Which is faster.