Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / guest

Answers were Sorted based on User's Feedback



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

Answer / pavan_1981

no its not possible to use long columns in WHERE or ORDERBY
clause.other restrictios on LONG column are
1.there can be only colum of long data type in a table.
2.no constraints can be defined on long column.
3.a long column will not be cpied when u create a new table
from existing table using a subquery.

Is This Answer Correct ?    21 Yes 4 No

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

Answer / lakshmikanthan

while using where or order by clause in long datatype column . error will come LIKE
ORA-00997: illegal use of LONG datatype .

And another points is :
1. only one long data type allowed in a table
2. cannot able to create the constraint in a long data type column in a table
error :
ORA-02269: key column cannot be of LONG datatype.

Is This Answer Correct ?    0 Yes 0 No

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

Answer / bolearner

Long data type can't participate for any operation in SQL.

Only DML queries can be applied.

Can't apply any aggregate function on LONG colum.

Can't apply any analytical function on LONG colum.

Can apply sequence on LONG colum.

Can apply synonym for LONG column table.

Can create view for LONG column table and Mat view is not possible.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What are the popular database management systems in the it industry?

0 Answers  

List different type of expressions with the example.

0 Answers  

hi..........i m Accenture employee...Accenture is an IT company having itz branches in India at Mumbai, Pune,Delhi, Hyderabad, Chennai and Bangalore....Presently there are openings here for SAP, Testing, Oracle,Java,.NET,MAinframe and Peoplesoft...... I am a software engineer working with Accenture,Mumbai....u can mail me in your resume..i`ll forward it to our HR team...my mail id: pankit.lodaya@accenture.com

8 Answers   Wipro,

What is the difference between subquery and correlated query?

0 Answers  

Write the alter statement to enable all the triggers on the t.students table.

0 Answers  

in procedure how to return a value

3 Answers   Wipro,

What is function and procedure in pl sql?

0 Answers  

What is an implicit commit?

0 Answers  

How do you remove duplicate records from a table?

0 Answers  

How can I pass the inner procedure value to outer procedure ?

2 Answers  

What is database white box testing and black box testing?

0 Answers  

I need a function for a train ticket reservation please answer it thanks in advance

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories