What are cursors?




Answers were Sorted based on User's Feedback



What are cursors?..

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

What are cursors?..

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

What are cursors?..

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




What are cursors?..

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

Post New Answer



More Data Warehouse General Interview Questions

What are the different problems that ?Data mining? can solve?

0 Answers  


How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.

1 Answers   IBM,


i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????

0 Answers   Wipro,


How to use the tool Ontobulider

1 Answers  


What Oracle tools can be used to design and build a W/H?

1 Answers  






What is Drill by? drill through?

1 Answers   CMC, iFlex,


Write a short note on data warehousing & three-Tier Warehouse architecture in detail.

1 Answers  


What is a look up function? What is default transformation for the look up function?

1 Answers  


What are diagrams?

0 Answers   InfoAxon Technologies,


if source contain 10records how you identify header and footer

2 Answers   Polaris,


Difference between slicing and dicing with example?

2 Answers  


What is Active Datawarehousing?

0 Answers  






Categories