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...

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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How delete all data from all tables in sql?

953


What are the ways on commenting in a pl/sql code?

1140


Can a procedure in a package be overloaded?

1047


Is there a 64 bit version of ssms?

962


what are properties of a transaction? : Sql dba

1094


What does t sql mean?

951


Why schema is used in sql?

1057


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

1128


Does sql profiler affect performance?

1000


Give the order of sql select?

1142


How do you use a while loop in pl sql?

1016


What are the types of functions in sql?

1022


What is the difference between local and global temporary table?

1053


How do you use collections in procedure to return the resultset?

2245


What is the best free sql database?

1058