How many LONG columns are allowed in a table?
- 6 Answers
- 22035 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 |
Does group by remove duplicates?
Which command is used to call a stored procedure?
Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.
What is %s in sql?
What are the differences between in and exists clause?
How do you write an inner join query?
What is a loop in sql?
how are rank and dense rank being alloted for column with same values over a particular column
How can you get sql*loader to commit only at the end of the load file? : aql loader
What is the maximum size of sqlite database?
What version is sql?
Define SQL and state the differences between SQL and other conventional programming Languages?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
