Interested to Buy Any Domain ? << Click Here >> for more details...
When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 56949 Views
- Accenture, HCL, Infosys, I also Faced
- E-Mail Answers
Answer Posted / ritesh goyal
When query is fired, Oracle will validate the syntax and semantics of the statement then creates a dynamic plan to execute it. retrieves the data from various datafiles and put it in an implicit cursor which is private SQL area for this query.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How does a trigger work?
What is implicit cursor in pl sql?
What is sql partition function?
Can variables be used in sql statements?
Why is the cursor important?
What is dialect in sql?
Is sql between inclusive?
What are different clauses used in sql?
What are the different types of functions in sql?
What is indexes?
What is difference between sql function and stored procedure?
Does sqlite need a server?
How will you distinguish a global variable with a local variable in pl/sql?
How to rename a table?
Is join and inner join the same?
