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
How to handle multi value dimensions?
Difference between cold fusion mx 6 and cold fusion mx 7?
Explain if a flat file cotains 1000 records how can I get first and last records only?
What are the different types of fact tables used in data warehousing?
Explain what is the difference between view filter and report filter?
What are target types on the server?
What is difference between model & package?
How to pivot data using informatica when you have variable amount of pivot rows?
Explain is fact table?
What is the difference between er modeling and dimensional modeling?
What are the advantages of cold fusion?
What are the design methods of data warehousing?
Explain the structure of cold fusion?
What are the methodologies of data warehousing?
What is the difference between constraind base load ordering and target load plan?