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

What is the primary key?

700


Why is nosql good?

777


What are sql triggers used for?

722


Is primary key is clustered index?

724


How do you optimize a query?

733






How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

798


How many indexes can be created on a table in sql?

685


Which command is used to delete a package?

773


i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1279


What is pl sql in oracle?

786


What problem one might face while writing log information to a data-base table in pl/sql?

761


Why do we need sharding?

730


What are the query optimization techniques?

711


Can a view be mutating? If yes, then how?

753


What is column?

723