select * from emp
what happened internally when we write this query in the sql
prompt?
- 5 Answers
- 6630 Views
- I also Faced
- E-Mail Answers
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 to pass a parameter to a cursor in oracle?
What are the data types in oracle?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
Which is faster join or subquery in oracle?
How index is implemented in oracle database?
How to count groups returned with the group by clause in oracle?
Explain the use of compress option in exp command.
How do I use unicode codesets with the weblogic jdriver for oracle driver?
How to create a stored function in oracle?
How do I learn what codesets are available in oracle?
how can we store any pdf file in oracle
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
Is truncate autocommit in oracle?
How would you go about verifying the network name that the local_listener is currently using?
