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 / bolearner

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of pl/sql table?

1067

What is difference between sql and excel?

1095

how to dump a table to a file with 'mysqldump'? : Sql dba

1036

What are the operators in sql?

1030

Are stored procedures faster than dynamic sql?

1041

how to select first 5 records from a table? : Sql dba

978

What is synonyms?

1057

What is dcl in sql?

962

What is a heap in sql?

1072

what are tables and fields? : Sql dba

1056

What is the advantage of nosql?

1061

What is secondary key?

934

How can use stored procedures in sql?

1140

What is interval partition?

1056

How to use sql*plus built-in timers?

1201