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
Is there any difference in testing database and data ware housing?
Where the cache files stored?
Explain is olap databases are called decision support system true/false?
How can you set the session management?
What are data modeling and data mining? Where it will be used?
what are the different views that are considered when building an object-oriented software system?
How can we run the graph? How can we schedule the graph in unix?
What are components of report studio?
Explain the main differences between star and snowflake schema?
Explain the difference between keylokup and joiner?
What is perform recovery?
What are Aggregate tables?
What is Analysis Services?
What is "method/1"?
What is operational data store (ods)?
