Answer / suresh kumar somayajula

Cursor : It's a private SQL worksheet area where we can
execute SQL commands and processing information.
The purpose of the Cursor is, PL/SQL execution block will
process only one records means it will return only one
records.If we want to retrieve or process more number of
records we use the "Cursors".
These are of two types.
1. Implicit Cursor 2. Explicit cursors.

Thank you,
Suresh

Answer / aravind

Cursor is used to process multiple rows using pl/sql.

Answer / sri

mainly cursor is used to to process the multiple records
from database

Answer / selvaraj v , anna university c

Cursors allow row-by-row processing of the result sets.
Retrieve more than one rows from table or database to use
Curosrs.

Answer / chandu

to perform multiple rows accessing.

type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...

1 Answers   Satyam,

What is record in pl sql?

0 Answers  

What are the new features in Oracle 10g. Compared to Oracle 9i?

1 Answers   Polaris,

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

16 Answers  

suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??

5 Answers   Keane India Ltd,

What operators deal with null?

0 Answers  

What Is a Trigger? How Do You Use It?

3 Answers  

What is lexical units in pl sql?

0 Answers  

What are the various restrictions imposed on view in terms of dml?

0 Answers  

what is innodb? : Sql dba

0 Answers  

What is Temp Table and type of temp table?

1 Answers   HP, SLK,

Is merge a dml statement?

0 Answers