What are the PL/SQL Statements used in cursor processing ?

Answer Posted / nishi

Declaring a CURSOR

Open the CURSOR

FETCH the rows from the CURSOR

CLOSE the CURSOR...

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain foreign key in sql?

809


What are the types of views in sql?

790


What is the primary use of normalization?

731


what is single byte over head in oracle..?

2136


what is a tablespace? : Sql dba

800


Write a sql select query that only returns each name only once from a table?

785


What is anonymous block in sql?

862


What is the difference between function, procedure and package in pl/sql?

798


How can we implement rollback or commit statement in a trigger?

806


What is restrict in sql?

780


What is the purpose of cursors in pl/sql?

822


What is the need of merge statement?

791


How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

891


How do you pronounce sql?

757


How many types of index are there?

743