select * from emp
what happened internally when we write this query in the sql
prompt?
Answers were Sorted based on User's Feedback
it will display all the records of emp table.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
How to retrieve data from an cursor to a record?
What is E-R diagram ?
2 Answers CGI, Keane India Ltd,
List the types of joins used in writing subqueries?
Explain oracle’s system global area (sga).
How to connect asp pages to oracle servers?
How to change user password in oracle?
What is sharded cluster?
What is oracle server autotrace in oracle?
How you find out version of installed workflow?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
How do we get field details of a table?
How would you begin to troubleshoot an ORA-3113 error?