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 is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2552

Is it mandatory for the primary key to be given a value when a new record is inserted?

1252

What is the basic form of sql query?

996

Explain the uses of a database trigger?

1086

Explain the structure of pl/sql in brief.

1139

What are the benefits of triggers?

1217

what is csv? : Sql dba

1049

What is pl sql package?

1071

Can we rollback delete command?

1038

What are the types of variable use in pl sql?

1138

What is plpgsql language?

1142

What steps server process has to take to execute an update statement?

1017

What is oracle and pl sql?

1159

Name some usages of database trigger?

1084

Does sql backup shrink transaction log?

1045