What are cursors? Explain different types of cursors?
Answers were Sorted based on User's Feedback
Answer / preethi
Cursors are work areas used for internal processing in
order toexecute an SQL statement.
Two tpes of Cursors
Implicit Cursors and Explicit Cursors.
Explicit Cursors can be further classifed into three
Named Cursors,Parameterized Cursors and Ref Cursors
Is This Answer Correct ? | 28 Yes | 8 No |
Answer / daudkhan
A point to context area which has infromation for Oracle to
process SQL statements.
Cursors allow to fetch rows returned by a select statement.
Implicit cursor: Automatically declared
Explicit cursor: defined by programmer
Is This Answer Correct ? | 14 Yes | 4 No |
Answer / banoj swain
cursor is nothing but a pointer pointing to the context area assigned by oracle for processing of sql statement.pl/sql programs control context area by using cursor.
types:1)static 2)dynamic or ref cursor
again static is of two types
1)explicit 2)implicit
dynamic of two types:
1)strong 2)weak
Is This Answer Correct ? | 9 Yes | 4 No |
Answer / siva
cursor is nothing but buffer area it is process by multiple records and also record by record process.
they are two types
1.implicit cursor:- it is returned only single value.(it is created by default system )
2.explicit cursor:- it is returned multiple values.( it is created by user).
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vishnuvardhan reddy
in db2 there are two types of cursors
1.scrolable cursor
2.non scrolable cursor
scrolable cursor:
scrolable cursor can be moved in sequential
forword (or)backword direction in the resultant table.
Non scrolable cursor:
simplest cursor is the non scrolable cursor
it is always moved in a sequential direction.
Is This Answer Correct ? | 2 Yes | 10 No |
What are cursors? Explain different types of cursors?
In which table collections errors are stored.
What are data modelling techniques?
I have a few records all are same structures data, I want to store data in multiple targets how
0 Answers CTR, Infosys, Polaris,
Given an employee table, how would you find out the second highest salary?
What is database design and development?
What is dbms and its application?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
agregator gives one to many records or many to one record
What is the physical representation for a many-to-many relationship?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
What are triggers? How many triggers you can have on a table?