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

What is the scope of a local variable?

1119

How can I see all tables in oracle?

1060

Why do you use stored procedures and state some of its disadvantages?

1071

What is the max number of columns in an oracle table?

1044

How to loop through data rows in the implicit cursor?

1116

Why do we use bulk collect in oracle?

1103

How to get last row id?

1049

Explain the blob datatype?

1122

Explain an exception?

1053

Explain enable novalidate constraint.

1129

What is a tns file?

1040

How to grant create session privilege to a user in oracle?

1050

How to use "in" parameter properly?

1116

What is meant by joins?

1106

Explain a synonym?

1086