select * from emp
what happened internally when we write this query in the sql
prompt?
Answer Posted / purna
ALL DATA R STORED IN D PHYSICAL LAYER .....WHEN WE WRITE A QUARY D DATA WILL COM FROM PHYSICAL LAYER 2 SGA (SYSTEM GLOBAL AREA) THROUGH SQL*PLUS LOGICAL LAYER AND GIVES D OUTUT IN D VIEW LAYER
PHYSICAL LAYER...>SQL*PLUS LOGICAL LAYER...>SGA...>VIEW LAYER
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is catalog in Oracle?
How to drop an index in oracle?
What are the uses of a database trigger?
What are the common oracle dba tasks?
Explain the use of grant option in imp command.
How do I uninstall oracle 11g?
What is oracle sid?
How to create a temporary table in oracle?
How can you merge two tables in oracle?
How do I uninstall oracle client from windows?
What are the major difference between truncate and delete?
What are the different types of trigger and explain its various uses and functions?
How to use "startup" command to start default instance?
How to create an oracle database?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?