When we give SELECT * FROM EMP; How does oracle respond?
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 |
Post New Answer View All Answers
How do you go back in sql?
what are numeric data types? : Sql dba
How many columns should be in an index?
How many types of triggers are there in pl sql?
Which data type is a composite type?
Define sql delete statement.
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
Does truncate free space?
Why do we use cursors?
What is a boolean in sql?
What are the different types of database management systems?
Enlist the characteristics of pl/sql?
Explain about various levels of constraint.
What is database white box testing and black box testing?
what is an index? : Sql dba