IF WE GIVE SELECT * FROM EMPLOYEES MEANS THE ORACLE WILL DO THE FOLLOWING.

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

Question Posted / d.elumalai

Answer Posted / d.elumalai

IF WE GIVE SELECT * FROM EMPLOYEES MEANS
THE ORACLE WILL DO THE FOLLOWING.

1.SYNTACTIC CHECK
2.SEMANTIC CHECK
3.HARD PARSING
4.SOFT PARSING

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the types of operators available in sql?

1129

Is pl sql useful?

1038

What is sql dialect?

1180

What is secondary key?

989

What is difference between stored procedure and trigger?

1252

Can you have more than one key in a database?

995

Does sap use sql?

1041

How to create a menu in sqlplus or pl/sql?

1169

What are keys in sql?

1042

Define commit?

1053

what is the difference between $message and $$message? : Sql dba

1041

What is update query?

1035

What is cursor in pl sql with examples?

1091

Can you sum a count in sql?

1061

What is sql lookup?

974