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 the key features of chameleon that separates it from other algorithms?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
What do you mean by static and local variable?
How to test report in reportnet?
What is the difference between filter and lookup transformation?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
Explain why denormalization is promoted in universe designing?
Explain what is full load & incremental or refresh load?
What is surrogate key? Explain with examples.
Explain what are the mapping paramaters and maping variables?
What is the function of surrogate key in data warehousing?
Can we have multiple application.cfm file in an application?
What is the main difference between star and snowflake star schema? Which one is better and why?
Explain can report net connect multiple datasource at a time in report creation time?
What is data analytics in simple terms?