what is the cursor and use of cursor in pl/sql ?

Answer Posted / prince pradeep

cursor is a handle or a pointer to a context area;
(context area is a memory area where sql statements are processed)
cursors are used to retrieve multiple records from data base

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you write a complex sql query?

585


how to rename an existing column in a table? : Sql dba

509


Can you inner join the same table?

525


What are all ddl commands?

545


Why do we use sql constraints?

655






What are stored procedures used for?

533


What are dml commands?

524


How do I delete a trigger?

541


Is sql sequential or random?

535


What are pl/sql cursors?

561


what is a trigger in mysql? Define different types of trigger. : Sql dba

548


how many sql ddl commands are supported by 'mysql'? : Sql dba

523


What is the unique index?

525


What is trigger types of trigger?

550


Is sql similar to python?

535