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
Explain me what are data marts?
Explain the difference between dw and bi?
What function should we use to display the value entered or selected by a user in response to a prompt?
Explain the definition of normalized and denormalized view?
Explain what is a cube in data warehousing concept?
What are the differences between star and snowflake schema?
Explain how to generate iqd file from framework manager?
What is difference between e-r modeling and dimensional modeling?
What is data warehosuing hierarchy?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
What is the difference between agglomerative and divisive hierarchical clustering?
What is meta data and system catalog?
What is static and local variable?
What is the differences between star and snowflake schemas?
What is your spectra photometer working principles?