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 start instance with a minimal initialization parameter file?

1040

What is a nested table?

1057

Why does Oracle not permit the use of PCTUSED with indexes?

2424

What is ordinary table in oracle?

1156

List out the difference between commit, rollback, and savepoint?

1031

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1865

What are named parameters?

1089

How to rename an index in oracle?

1113

What is the simplest tool to run commands on oracle servers?

1009

How to create a single index for multiple columns?

1037

How to load excel data sheet to oracle database

1024

How many types of table in Oracle?

1119

How to write a query with a left outer join in oracle?

1061

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2043

How to insert multiple rows with one insert statement in oracle?

1085