What are cursors?
Answers were Sorted based on User's Feedback
Answer / umasankar
A cursor is a handle or name for sql area
two types of cursors they are
Explicit cursor: Created by user
Implicit Cursor: created by oracle automatically when ever
DML is performed.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Answer / swapna
They are used to display information of a table into
effective number and also display more than one record at a
time.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / harshad
As this would be not specific DW Concept but rather more on
RDBMS Programming concept.
Cursor is nothing but the pointer of memory addres to your
query result.
Explicit Cursor : User need to specifically declared in
your program (procedure/function)
Implicit Cursor : Any DML; it will handled by RDBMS.
Is This Answer Correct ? | 1 Yes | 0 No |
What is recovering sessions?
Code the tables statement to produce a multi-level frequency?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
What is a look up function? What is default transformation for the look up function?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
What is partitioning? What are the types of partitioning?
How to pivot data using informatica when you have variable amount of pivot rows?
Explain which are the olap tools available that are supported by oracle?
What are the fundamental elements of the data warehouse?
What are the key features of chameleon that separates it from other algorithms?
Best Data Ware housing training institute in delhi
What is the difference between drill through and masterdetail reports?