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 are sql commands classified?

1084


How many postgresql users are there, worldwide?

1057


how to check myisam tables for errors? : Sql dba

1319


What is latest version of sql?

1041


how to use like conditions? : Sql dba

1105


How do you delete duplicates in sql query using rowid?

944


What are secondary keys?

969


How do you truncate?

902


Is delete faster than truncate?

1002


How do I run a sql query?

1012


How many sectors are in a partition?

1076


Does db2 use sql?

942


Is sql similar to python?

969


What are the types of variables use in pl sql?

1038


how do you tune the slow running queries in oracle db , explain the methodology

2714