select * from emp what happened internally when we write this query in the sql

Categories >> Software >> Databases >> Oracle >> Oracle General
Suggest New Category

select * from emp
what happened internally when we write this query in the sql
prompt?

Question Posted / mahikatkam

5 Answers
7661 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

select * from emp what happened internally when we write this query in the sql prompt?..

Answer / dilip

it wil select all the data from table....

Is This Answer Correct ?

5 Yes

3 No

select * from emp what happened internally when we write this query in the sql prompt?..

Answer / dinesh chandra

it will display all the records of emp table.

Is This Answer Correct ?

2 Yes

1 No

select * from emp what happened internally when we write this query in the sql prompt?..

Answer / purna

ALL DATA R STORED IN D PHYSICAL LAYER .....WHEN WE WRITE A QUARY D DATA WILL COM FROM PHYSICAL LAYER 2 SGA (SYSTEM GLOBAL AREA) THROUGH SQL*PLUS LOGICAL LAYER AND GIVES D OUTUT IN D VIEW LAYER
PHYSICAL LAYER...>SQL*PLUS LOGICAL LAYER...>SGA...>VIEW LAYER

Is This Answer Correct ?

1 Yes

0 No

select * from emp what happened internally when we write this query in the sql prompt?..

Answer / vijay sonawane

show all records of table as output

Is This Answer Correct ?

0 Yes

1 No

select * from emp what happened internally when we write this query in the sql prompt?..

Answer / sanjay

query will not give any results

Is This Answer Correct ?

0 Yes

4 No

Post New Answer