It will retrieve all the columns of emp table. There is no need to check

When we give SELECT * FROM EMP; How does oracle respond?

Question Posted / geetha priya

Answer Posted / geetha priya

It will retrieve all the columns of emp table. There is no
need to check for conditions as there are no conditions
specified in the given command.

Is This Answer Correct ?

7 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What are the different schemas objects that can be created using pl/sql?

964

Can we call a function containing dml statements in a select query?

916

What is full join in sql?

937

What is the difference between Union and Union all. Which is faster.

1337

Can we use pl sql in sql server?

1007

How to display the records between two range in Oracle SQL Plus?

1097

How many parts of a pl sql block are optional?

1025

Explain exception handling in pl/sql?

987

Explain ddl statements in pl/sql?

956

What is equi join in sql?

1007

Why truncate is used in sql?

932

How can a function retun more than one value in oracle with proper example?

1025

What is the difference between the conventional and direct path loader? : aql loader

1108

how is exception handling handled in mysql? : Sql dba

1006

What is difference between pls_integer and integer?

906