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 the use of incremental aggregation? Explain me in brief with an example?
What is drill-through?
What is Discover and Execute in XMLA?
Can you pass sql queries in filter transformation?
How can we schedule the graph in unix?
Explain the definition of normalized and denormalized view and what are the differences between them?
What is the difference between star and snowflake schemas?
What is the difference between power center & power mart?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
What is the use of tabular model, tabular sql, tabular reference in real time application?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
Whether dimension table can have numeric value?
Explain what does level of granularity of a fact table signify?
What are the data marts?
For faster process, what we will do with the universe?
