SQL Plus - How many LONG columns are allowed in a table

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Go To First | Previous Question | Next Question

SQL Plus | Question 20 of 132

How many LONG columns are allowed in a table

Total Answers and Comments: 5

Last Update: September 05, 2008

Sponsored Links

Best Rated Answer

—

Submitted by: rampratap409

Only one column and this column can not be used in where clause or order by clause.

Above answer was rated as good by the following members:
ashaRane

July 16, 2005 00:49:08

Mathivanan

RE: How many LONG columns are allowed in a table

Only one Long column can be present in a table.

Is this answer useful? Yes | No

July 24, 2006 06:08:01

Shiv Mangal Rahi

RE: How many LONG columns are allowed in a table

Yeah. I do agree. Only one column of a table could be Long.

Is this answer useful? Yes | No

December 11, 2006 06:14:15

rampratap409

Member Since: September 2006 Contribution: 111

RE: How many LONG columns are allowed in a table

Only one column and this column can not be used in where clause or order by clause.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

March 05, 2007 06:38:47

Nikhil_4_Oracle

RE: How many LONG columns are allowed in a table

Hey all

You can have only one column of long in table And this table can`t have
Primary key Constraint.
--Nikhil

Is this answer useful? Yes | No

September 05, 2008 17:01:43

Gayathri Panchangam

Member Since: August 2008 Contribution: 2

RE: How many LONG columns are allowed in a table

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 useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank