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 CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
what is Table ?
Differnce between view and index
What is a snapshot log?
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
what is Single Byte Overhead...?
What are main difference between Stored Procedure and Functions.
How can Oracle users be audited?
What is the max number of columns in an oracle table?
Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?