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 trigger in pl sql with examples?

979

what is view? : Sql dba

912

Do foreign keys improve performance?

965

What is a memo field?

901

Does access use sql?

968

What are tables and fields in the database?

1023

What are the different types of triggers?

1052

Which command is used to delete a package?

1090

How to display the records between two range in Oracle SQL Plus?

1098

discuss about myisam index statistics collection. : Sql dba

906

How do you modify a column in sql?

938

What does inner join mean?

1061

Where is pl sql used?

904

what are the type of locks ? : Sql dba

897

Which normal form is best?

895