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

What is an inner join sql?

955


Is there a way to automate sql execution from the command-line, batch job or shell script?

918


Are dml statements autocommit?

984


what is a trigger? : Sql dba

974


What are analytical functions in sql?

969


Differentiate between pl/sql and sql?

1069


what is the command line end user interface - mysql? : Sql dba

925


How do I remove sql developer from windows 10?

1012


What is a parameter query?

1020


how to use in conditions? : Sql dba

958


Which software is used for pl sql programming?

929


list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

898


what are the differences between char and varchar? : Sql dba

1002


Which table is left in left join?

952


Is sql pronounced sequel or sql?

1213