Interested to Buy Any Domain ? << Click Here >> for more details...
How many LONG columns are allowed in a table?
- 6 Answers
- 24433 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 |
Are there any features that are decommissioned in 11g that are not present in 11g?
What do you understand by pl/sql records?
What is Raise_application_error ?
What is execution plan in sql?
What is the difference between microsoft access and sql?
What is the difference between UNIQUE KEY and UNIQUE INDEX?
explain the difference between delete , truncate and drop commands? : Sql dba
Explain aggregate functions are available there in sql?
What is the Difference between Procedure and Function.Can we call a Function in a DML?
What is multiple partition?
Write an sql query to select all records from the table?
what is organisational index?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
