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
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
What does level of granularity of a fact table signify?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
How to reduce warnings?
How to design file watch jobs?
What is the difference between olap and oltp?
What is critical column?
What is Star Schema?
How can we load the time dimension?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
What are session timeout and application timeout? Where we have to do this process?
How to create different types of templates?
What is the definition of cube in datawarehousing?
what is user variable in affinium campaign? and some real time examples.
What are the different types of data warehousing?
