Answer Posted / swamy.l.n
1.A PRIVATE MEMORY/BUFFER.
2.IT IS USED TO HOLD THE DATA FROM TABLES OR VIEWS IN
MEMORY LOCATION FOR MANIPULATION PURPOSE.
3.VALID IN PL/SQL BLOCK ONLY.
4.ARE VARIABLE THAT YOU CAN DEFINE IN THE DECLARE SECTION
OF THE PL/SQL BLOCK.
ORACLE USES WORK AREA CALLED PRIVATE SQL AREAS TO EXECUTE
SQL STATEMENT AND STORE INFORMATION.
5.IT IS A VIRTUAL TABLE TO PROCESS MULTIPLE RECORDS IN
PL/SQL CONSTRUCT.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are templates in which way it is help full?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
Explain the definition of normalized and denormalized view and what are the differences between them?
Explain piconet?
How to stop a batch?
What is the use of incremental aggregation? Explain me in brief with an example?
Store (and count) non-fact records?
Explain swot analysis?
Which columns go to the fact table and which columns go the dimension table?
Explain degenerate dimension table?
How to reduce warnings?
What is difference between model & package?
What are the other names given to data warehousing?
Explain why denormalization is promoted in universe designing?
Explain multivalued dependency?
