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
How do I spool to a csv formatted file using sqlplus?
What is a cursor in oracle?
What are transaction isolation levels supported by oracle?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
Explain the use of show option in imp command.
What is integrity and what is constraint??Explain with example
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
How to assign values to data fields in record variables?
State some uses of redo log files?
How to create tables for odbc connection testing?
What is oracle datasource?
How to recover a dropped table in oracle?
What is analyze command used for?
Explain compound trigger in oracle?
How to start an oracle instance?