When we give SELECT * FROM EMP; How does oracle respond?
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 difference between primary and secondary key?
What are sql built in functions?
Explain the savepoint statement.
what is the difference between truncate and delete statement? : Transact sql
what does it mean to have quoted_identifier on? : Sql dba
What are different categories of sql commands?
What do you understand by pl/sql records?
What is the difference between having and a where in sql?
Why function is used in sql?
Can we create table in function?
What is difference between function and trigger?
What is implicit cursor in pl sql?
what is unique key constraint? : Sql dba
How to select unique records from a table?
What are the types pl/sql code blocks?