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

How to convert characters to times in oracle?

1071

How can we delete duplicate rows in a table?

1040

How to bring a tablespace online?

1145

How to assign a table row to a record variable?

1095

Explain view?

1091

What is MTTR advisor in Oracle?

1142

Why do we use coalesce function in oracle?

1169

How to loop through data rows in the implicit cursor?

1120

why dont we assign not null constraint as table level constraint.

2798

What is sharded cluster?

1071

Explain an index segment?

1160

How to select some columns from a table in oracle?

1175

What is oracle and what are its different editions?

1121

What is set verify off in oracle?

1160

What is a directory object?

1137