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

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

Question Posted / dilip

Answer Posted / dilip

Is This Answer Correct ?

5 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Which environment variables are absolutely critical in order to run the OUI?

2080

How to create a new view in oracle?

1024

What are the differences between primary key and unique key?

955

How to use existing values in update statements using oracle?

1022

How to call a stored function with parameters?

982

How to convert a string to a date in oracle database?

1007

What is Undo Management Advisor in Oracle?

1049

How to invoke the data pump import utility?

1089

How to build data dictionary view an new database?

968

How to drop a stored function?

1095

How to use group functions in the select clause using oracle?

1035

What is raw datatype?

1087

What is where clause in oracle?

990

How to apply filtering criteria at group level in oracle?

1000

How many types of segments in Oracle?

1025