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 an inner join sql?

1034

what are date and time functions in mysql? : Sql dba

980

Is join same as left join?

1042

what is user defined functions? : Sql dba

1037

Which normal form is best?

951

What are the key differences between SQL and PL SQL?

1218

what is the command line end user interface - mysql? : Sql dba

984

can sql servers linked to other servers like oracle? : Sql dba

1010

What is user in sql?

1027

What is duration in sql profiler trace?

1085

How does one load ebcdic data? : aql loader

1178

Is sql database free?

983

How do I run a query in pl sql developer?

998

what is index? : Sql dba

1009

what is heap table? : Sql dba

1108