When we give SELECT * FROM EMP; How does oracle respond?
Answer Posted / wasim
User Level Process sends the query to Server level process
where in the query gets checked syntactically first. If the
syntax is correct then the query will get break down into
parts to evaluate what has to be done.
Oracle Engine then parses the query and understands that all
the rows from employee table has to be retrieved, before the
statement execution it will check whether the data is
available already in SGA. If its available then its will
send output to user, else it will execute the statement and
fetch the output from database and store it in database
buffers and then will pass on to user.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the different type of sql's statements ? : Sql dba
Does asenumerable execute the query?
Who is the owner of mysql database?
How does postgresql compare to mysql?
How do I audit the sql sent to the server?
What are pl/sql cursors?
What is a stored procedure in sql with example?
how does a local variable is defined using t-sql? : Transact sql
Is sql dba a good career? : SQL DBA
Are stored procedures faster than dynamic sql?
Explain what is dbms?
How do you create a db file?
difference between anonymous blocks and sub-programs.
What is the difference between a procedure and a function?
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...