Interested to Buy Any Domain ? << Click Here >> for more details...
How many LONG columns are allowed in a table?
- 6 Answers
- 24422 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 |
Explain the types of joins in sql?
What are Lexical Parameters.How They are used in Reports 6i
What is the difference between sum and count in sql?
what is data integrity? : Sql dba
How to use transactions efficiently : transact sql
will function return more than one value how
What is the difference between anonymous block and named block or stored procedure?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
what is not null constraint? : Sql dba
What are the events on which a database trigger can be based?
What is a constraint?
need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
-
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)
