Interested to Buy Any Domain ? << Click Here >> for more details...
When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 57870 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 are the performance and scalability characteristics of mysql? : Sql dba
How delete all data from all tables in sql?
What are the events on which a database trigger can be based?
What is primary key secondary key alternate key candidate key?
What is the difference between sql and isql*plus?
Can you upgrade sql express to full sql?
What is sql server and ase?
Can triggers stop a dml statement from executing on a table?
how to enter numeric values as hex numbers? : Sql dba
How to run sql*plus commands in sql developer?
What language is oracle sql developer?
What are the advantages of sql?
What are the different type of joins in sql?
What is pl sql in oracle?
What is localdb mssqllocaldb?
