How many LONG columns are allowed in a table?
- 6 Answers
- 22020 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 meant by nl2br()? : Sql dba
How do you delete data from a table?
what is table? : Sql dba
which tcp/ip port does sql server run on? : Sql dba
What are the query optimization techniques?
What is the purpose of normalization?
What is lexical units in pl sql?
what is oltp (online transaction processing)? : Sql dba
How many sql are there?
How run sql*plus commands that are stored in a local file?
What is a sql trace file?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
Explain the difference between sql and mysql.
What is auto increment in sql?
write an sql query to find names of employee start with 'a'? : Sql dba
