How many LONG columns are allowed in a table?
- 6 Answers
- 22025 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 scalar data type in pl sql?
what is isam? : Sql dba
What is the use of function in sql?
What does the file extension accdb stand for?
what is the different between now() and current_date()? : Sql dba
What is pl sql in oracle?
What is a design view?
What are the syntax and use of the coalesce function?
Why trigger is used in sql?
What is normalization? How many normalization forms are there?
what is top in tsql? : Transact sql
Can we join 3 tables in sql?
What is primary and foreign key?
Does truncate remove indexes?
What are some emotional triggers?
