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 is the use of pl/sql table?

996

List different type of expressions with the example.

890

What does trigger mean in slang?

1000

What are the usages of sql?

1007

Which tcp/ip port does sql server run?

955

how to enter numeric values as hex numbers? : Sql dba

1003

What is pl sql architecture?

919

What is the difference between instead of trigger and after trigger?

947

When do we use triggers?

1025

what is the difference between truncate and drop statements? : Sql dba

1030

how to create a new table in mysql? : Sql dba

932

The select into statement is most often used to create backup copies of tables or for archiving records?

1000

What is sqlexception in java?

939

What is pl sql in dbms?

899

How to download oracle sql developer?

1055