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

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

0 Answers  


Explain how to get the first 100 rows from the flat file into the target?

0 Answers  


what are the types of dimension tables

19 Answers   Infotech,


How to load the time dimension?

0 Answers  


How can we run the graph?

0 Answers  






How to export mappings to the production environment?

0 Answers  


What are the advantages and disadvantages of reporting directly against the database?

0 Answers  


what are the major three types of modeling used?

0 Answers   InfoAxon Technologies,


How can Oracle Materialized Views be used to speed up data warehouse queries?

3 Answers  


What is Data purging?

8 Answers   TCS,


How can we run the graph? What is the procedure for that?

0 Answers  


Explain what are the methodologies of data warehousing?

0 Answers  






Categories