Interested to Buy Any Domain ? << Click Here >> for more details...
How many LONG columns are allowed in a table?
- 6 Answers
- 24949 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 the difference between a procedure and a function?
What is embedded sql what are its advantages?
How do I remove sql plus from windows 10?
Which query operators in sql is used for pattern matching?
How to call shell script from pl sql procedure?
what is a foreign key ? : Sql dba
What do you think about pl/sql?
What is t sql used for?
Mention what are different methods to trace the pl/sql code?
What are the different type of joins in sql?
Can we write ddl statements in functions?
What is scope of pl sql developer in future?
What are the parameter modes supported by pl/sql?
What do you mean by “trigger” in sql?
How do I view tables in mysql?
