Interested to Buy Any Domain ? << Click Here >> for more details...
How many LONG columns are allowed in a table?
- 6 Answers
- 24366 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 |
using subquery how can i calculate working days in a month?
How many triggers can be applied to a table?
How do you update a sql procedure?
how to start mysql server? : Sql dba
Explain the PL/SQL compilation process.
Can there be more than one function with a similar name in a pl/sql block?
What is sql constant?
What is CYCLE/NO CYCLE in a Sequence?
Is left join same as inner join?
How can we debug in PL/SQL?
Can we insert in sql function?
Types of joins ?
3 Answers Digital GlobalSoft, HeadStrong,
-
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)
