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 is the difference between ods and oltp?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
Why we use repository connectivity?
What is the difference between view materialized view and view?
What is is a star schema?
What is data warehosuing hierarchy?
What are the stages that are required in data warehousing?
What is a real-time data warehouse?
What are the design methods of data warehousing?
What are data modeling and data mining?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
What is the difference between mapping parameter & mapping variable in data warehousing?
What are the advantages of raid 1, 1/0, and
How can we schedule the graph in unix?
