it will display all the records of emp table.

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

Question Posted / dinesh chandra

Answer Posted / dinesh chandra

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do I uninstall oracle 11g?

1176

Explain a synonym?

1088

How to write date and time literals in oracle?

1044

Design database draw er diagram for a certain scenario ?

4627

How to create a table interactively?

1166

what are archived logs?

2260

What is procedure overloading in oracle?

1113

Is primary key indexed by default in oracle?

1048

How can I get column names from a table in oracle?

1103

How to invoke the data pump export utility?

1252

How to insert a new row into a table in oracle?

1216

When do you get a .pll extension in oracle?

1191

How to delete a column in an existing table?

1130

Can objects of the same schema reside in different tablespace?

1103

What is the use of file param in imp command?

1216