How many LONG columns are allowed in a table?
- 6 Answers
- 22959 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
What is the difference between left outer join and left join?
Which is the correct statement about truncate and delete?
Define implicit and explicit cursors.
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
Difference between NVL, NVL2 and NULLIF
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
Does sql between include endpoints?
Write a simple program on cursors
How to run sql commands in sql*plus?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
