SQL Plus - Is it possible to use LONG columns in WHERE clause or ORDER BY

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Go To First | Previous Question | Next Question

SQL Plus | Question 21 of 132

Is it possible to use LONG columns in WHERE clause or ORDER BY

Total Answers and Comments: 3

Last Update: February 06, 2007

Sponsored Links

Best Rated Answer

—

Submitted by: rampratap409

NO, Long column can not used in where, order by clause

A table can have only one long column

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

July 11, 2005 15:30:05

Vikas

RE: Is it possible to use LONG columns in WHERE clause or ORDER BY

not possible

Is this answer useful? Yes | No

December 08, 2006 08:20:44

rampratap409

Member Since: September 2006 Contribution: 111

RE: Is it possible to use LONG columns in WHERE clause...

NO Long column can not used in where order by clause

A table can have only one long column

Is this answer useful? Yes | No

1 0

Overall Rating: +1

February 06, 2007 06:49:18

Murugavel

RE: Is it possible to use LONG columns in WHERE clause...

only one long col allowed in a table.

Is this answer useful? Yes | No

User Name		Remember Me?
Password

Question Bank