don

• Oct 18th, 2005

 

when u give  SELECT * FROM EMP;

the server check all the data in the EMP file and it displays the data of the EMP file

don

• Oct 18th, 2005

 

when u give  SELECT * FROM EMP;

the server check all the data in the EMP file and it displays the data of the EMP file

Shanker

• Oct 24th, 2005

 

Its gives complete employees details which are present in emp table.

Muruganandam

• Oct 24th, 2005

 

If we give select * from emp then oracle response by displaying all the records with all its column. This is used to view the full sturcture of the table with all its records with field name as its column title.

Rajesh Sakhamuri

• Nov 3rd, 2005

 

Which data u have in the EMP table at the database,that data willbe displays.

asdf

• Nov 3rd, 2005

 

the SQL parser will first checks the which command it is.And then the table table, columns which are selected and then the display of selected lsit.

Dhayanand darshanala

• Nov 3rd, 2005

 

Select All the rows from the Emp table

shobhit sharma

• Nov 8th, 2005

 

when we give select * from emp; The server search for the database schema called " Emp" here. If there exists any schema called "emp", then it checks its all attributes then match this attribute with the arguments in after the select statement. If everthing is allright then it will display all the rows with all its attributes.

bhaskar

• Nov 9th, 2005

 

wellfirst it checks the data dictionary part in the blockand then it checks the table emp and the concerned record block leveland gives the answer

shuaib

• Nov 11th, 2005

 

it will return the all rows from emp table.

ravi.chand

• Nov 15th, 2005

 

oracle will search for the emp table in the database and select the rows randomly.

veeraswamy

• Dec 9th, 2005

 

first it check the emp table present or not,

if it is present it wiil display all the contents of emp table.

Deepa Jayaraj

• Dec 16th, 2005

 

Select * from emp;

At first the query will be checking for any syntax error. Since * has been given as the column to be selected, it will refer Data dictionary for all its columns and form the query to be compiled. Then SQL Parser will parse the query. Optimizer will choose either cost based Optimizer or rule based optimizer for performing this query. Then SQL Execution engine executes and gives the result ie., it will display all the records of Emp table.

Ritesh P. Medhe

• Dec 22nd, 2005

 

When select * or any query is fired against the database. The database engine first checks whether the user has rights to perform the specified action or not.

If he do not have rights to do so an error message wll be shown.

If he is allowed to do that the database engine will check for the specified object in the datafiles and display the results accordingly.

Thanks

Ritesh

srinivasakumar

• Mar 27th, 2006

 

first it checks for the schema whether that emp table is present in schema like (scott).then it selects all the columns and display them

ajay kumar verma

• Apr 6th, 2006

 

the server check all the data in the EMP file and it displays the data of the EMP file

nirav

• Jun 17th, 2006

 

in this statement select *from emp

step 1 : server check for the syntex is right or not

step 2: than it check for the object if it is exits it retrive the information from the object and give it bck to user.if not it display the error message : object does not exits.

sim

• Jan 10th, 2007

 

yes it displays all the rows and columns related to emp table

avate.avinash

 Profile Answers by avate.avinash 

• Jan 24th, 2011

 

It display all columns with data.

macmanoj

• Sep 19th, 2012

 

when you insert SELECT as the DRS statement,it starts working in the column level and retrieving the data from the column of the perticular table.The SELECT statement is a predefined statement in sql engine which performs in the column level only. Let us consider the EMP table, when we insert,

SQL>SELECT Ename from emp;

it will display all the employee name from the emp table.


suppose,
i insert

SQL>SELECT * from emp;

the above querry will display all the information from emp or we can say the entire information along with the structure of the emp table.SELECT works like a pointer which points the particular memory area of the particular column queried in your statement.where as "SELECT *" works as virtual pointer on the table level and derives the entire structure and information from the table.

Sathya

• Sep 23rd, 2012

 

It will fetch all the data from employee table..then u give a select * command..

sainath

• Sep 24th, 2012

 

syntax verification done from client only not in the server only valid sequel statements are send to the server if syntax is not correct client throws error

Rakesh

• Jun 29th, 2014

 

Check for syntax correct Then it will check weather the table is present or not in database is nothing but a Parsing
fetch the data

Sandip Muke

• Jul 29th, 2016

 

First it will do the syntax/ semantic check and if it is correct then an only that statement forward to the Oracle RDBMS server. After that Oracle will check whether that user has privilege or not. Then it enters into the Shared pool area in DD cache/ Row cache and check what type of this statement is SQL, PLSQL or Trigger and also check whether that statement is fired by anyone previously, if same statement already fired then it found the matching value and does the Soft parse and if not found then, it will generate the some hash value and store that hash value in namespace along with that statement and perform the Hard parse which is more costlier.

In that case Oracle does not know anything about table name, about *, nothing, so in that case it will ask to Data Dictionary what is meant by EMP (table) so DD tells to Oracle that EMP is a table.

Next Oracle will ask what is meant by *, who fired that select statement, whether he has access on that table and if yes then how I will go to perform the output of that table, are the statistics are available there?, etc. So depend upon the stats optimizer generate the some plan. This is end of Parsing phase.

Next is Execute phase: Whatever plan have selected it get into action.

Next is Fetch: After execution it fetch the data one row at a time and we get the required output.

Abdul Rahman

• Jul 18th, 2017

 

All rows from the EMP table are returned (output).