Interested to Buy Any Domain ? << Click Here >> for more details...
How many LONG columns are allowed in a table?
- 6 Answers
- 24383 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 purpose of update command in oracle?
Explain what is rdbms?
What is the difference between partitioning and sharding?
how many no of table can be join in a sql query.
What is oracle pl sql developer?
how tsql statements can be written and submitted to the database engine? : Transact sql
what is 'mysqldump'? : Sql dba
What is graph sql?
Which data dictionary views have the information on the triggers that are available in the database?
define join and explain different type of joins? : Sql dba
What is ROWID?
how many sql ddl commands are supported by 'mysql'? : Sql dba
-
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)
