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 would you change old and new values in an insert, delete and update triggers?

1023

How to pass parameters to procedures in oracle?

1042

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4370

How to find the duplicate rows count from employees table in oracle?

1097

Which are the five query types available in oracle?

953

What is a user account in oracle?

1121

What to do if the startbd.bat failed to start the xe instance?

1086

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2974

How to view existing locks on the database?

1056

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1054

How to view all columns in an existing table?

936

How to resolve the ORA-39133 error in Oracle?

1126

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1915

What do you mean by a database transaction & what all tcl statements are available in oracle?

994

What is the dynamic sql in oracle?

1081