Interested to Buy Any Domain ? << Click Here >> for more details...
When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 58729 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
What is parameter substitution in sql?
Explain what is table in a database?
How do I remove sql developer from windows 10?
What is compound trigger?
What does cursor do in sql?
What are commit, rollback, and savepoint?
Explain sql data types?
how many values can the set function of mysql take? : Sql dba
What is the file extension for sql database?
how to rename an existing table in mysql? : Sql dba
Why trigger is used in sql?
What is time based sql injection?
write an sql query to find names of employee start with 'a'? : Sql dba
How do I partition a table in sql?
What is a table in a database?
