Interested to Buy Any Domain ? << Click Here >> for more details...
When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 58731 Views
- Accenture, HCL, Infosys, I also Faced
- E-Mail Answers
Answer Posted / umashankar
1.The PARSER scans/reads the SELECT statement and splits it
into some logical units such.
i.e: keywords/reserved word, operators, expressions and
identifiers.
2. SEQUENCE TREE or QUERY TREE is built the logical steps
needed to transform the source data into the format as
needed by the end result.
3. The QUERY OPRIMIZER analyzes the query in various ways
and selects the series of steps that returns the end
results fastest way. The query tree is updated to record
this exact series of steps. The final, optimized version of
the query tree is called the execution plan.
4. The RELATIONAL ENGINE starts executing the execution
plan which was prepared by the Query Optimizer.
5.The RELATIONAL ENGINE requests the STORAGE ENGINE pass up
data from the rowsets requested.
6. The RELATIONAL ENGINE processes the data (returns all
column values from EMP table) returned from the storage
engine to the client.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
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...
What is pivot table in sql?
What are sql queries used for?
What is form and report?
what are myisam tables? : Sql dba
How do I partition in sql?
How do I order by ascending in sql?
What are analytic functions in sql?
What is difference between inner join and self join?
How much does sql cost?
What is rtm stands for?
explain the difference between myisam static and myisam dynamic. : Sql dba
Why do you partition data?
How can we optimize a sql query?
how to select unique records from a table? : Sql dba
