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

When we give SELECT * FROM EMP; How does oracle respond?

Question Posted / vaibhavi_dixit

Answer Posted / vaibhavi_dixit

When the above statment is fired, Oracle checks for
following things,
1.Syntax Correctness.
2.User Priviledges on Emp Table.
If the above two things are correct then, all columns and
all rows from Emp table are selected in an Implicit area
and then are send to User.

Cheers
VD

Is This Answer Correct ?    73 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to find 3rd highest salary of an employee from the employee table in sql?

1133

How to run pl sql program in mysql?

1071

How does sql developer connect to oracle database?

1051

What schema means?

939

How to return an array from java to pl/sql?

1181

Explain the types of joins in sql?

1073

How is sql used in oracle?

1037

How to make a copy values from one column to another in sql?

1082

explain access control lists. : Sql dba

1050

Is oracle sql free?

1037

What is the maximum number of columns in sql table?

1228

How do you pronounce sql?

1058

How to read xml file in oracle pl sql?

947

Will truncate release space?

989

What is the difference between jpql and sql?

1145