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

Answer / ramesh

Implicit Cursors --Occurs on behalf of every sql statement
Explicit Cursors --Named Cursors used in Plsql
Paramaeteried Cursors --Pass Paramters to a Named Cursor


Cheers,
Ramesh

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

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

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).

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.

agregator gives one to many records or many to one record

1 Answers   IBM,

How to use online Backups?

0 Answers  

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

0 Answers   Covansys,

Explain about network model?

0 Answers  

What is the system function to get the current user's user id?

4 Answers  

how will I find the duplicate rows count from employees tablein oracle.

2 Answers  

What are the constraints on severity level in raiseerror?

0 Answers  

Explain the role of indexing in databases?

0 Answers  

Which four data types cannot be used as a return type from a user-defined function?

0 Answers  

what is the use of foreginkey

2 Answers  

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

0 Answers  

Write the difference between case version and decode version.

2 Answers