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

How do you remove duplicates without using distinct in sql?

972

What is relationship? How many types of relationship are there?

1169

Explian rowid, rownum? What are the psoducolumns we have?

997

Can I create table without primary key?

993

How many commands are in sql?

1064

How do you respond to dementia behavior?

964

Why trigger is used in sql?

964

What is sqlexception in java?

981

Who is the owner of mysql database?

1055

What is query execution plan in sql?

1184

What is the sql query to display the current date?

1038

What is an implicit commit?

1048

what are aggregate and scalar functions? : Sql dba

1053

Does truncate free space?

1003

What do you understand by pl/sql cursors?

1082