Interested to Buy Any Domain ? << Click Here >> for more details...
When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 56987 Views
- Accenture, HCL, Infosys, I also Faced
- E-Mail Answers
Answer Posted / venky
when we fire this query on
first it will send to sql buffer
then sql buffer send to SGA
sGA send to sql*plus layer
this layer interact with the database server if the table
is exist in the database server , it will dispatch the all
rows to sql*plus layer
from this layer to SGA-----> output buffer
..
finally it wii display on the location of interface(screen)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the difference between delete and truncate statement in sql? : Sql dba
What are different types of statements supported by sql?
How do I sort a table in sql?
What is difference between sql and oracle?
What does sql stand for?
What is the cause of mutating table error and how can we solve it?
When is the update_statistics command used?
What is the usage of the distinct keyword?
Why is theta join required?
Why self join is used in sql?
What are the types of dbms?
What are the two virtual tables available at the time of database trigger execution?
How to read xml file in oracle pl sql?
Is truncate ddl or dml?
What is crud diagram?
