Interested to Buy Any Domain ? << Click Here >> for more details...
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 a relationship?
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.
What is aggregate fact table?
Explain hybrid slowly changing dimension?
Whether dimension table can have numeric value?
What is the use of tabular model, tabular sql, tabular reference in real time application?
What is is a star schema?
Explain what are the different types of data warehousing?
What is a fact, dimension, measure?
What are the difference between snow flake and star schema?
What are snapshots? What are materialized views & where do we use them?
What is Active Datawarehousing?
Explain ddl (data definition language)?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
How to stop a batch?
