How many LONG columns are allowed in a table?
- 6 Answers
- 22117 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 a primary key? Explain
What is identity column in sql server?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What is an emotional trigger?
What is set serveroutput on in pl sql?
Can a varchar be a primary key?
Explain correlated query work?
What is keys and its types?
Does sql backup shrink transaction log?
Can I create table without primary key?
What is group function in sql?
Explain about various levels of constraint.
Can we create clustered index without primary key?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
Is oracle sql free?
