What are the PL/SQL Statements used in cursor processing ?
Answers were Sorted based on User's Feedback
Answer / suresh kumar somayajula
Declaring a CURSOR
Open the CURSOR
FETCH the rows from the CURSOR
CLOSE the CURSOR...
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / nishi
Declaring a CURSOR
Open the CURSOR
FETCH the rows from the CURSOR
CLOSE the CURSOR...
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vijay
cursor
open
fetch
close
attributes
%found,
%notfound
%isopen
%rowcount
loop
whlie loop
for loop
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference among union, minus and intersect?
Can I call a procedure inside a function?
What is the size of partition table?
how many groups of data types? : Sql dba
What do you understand by pl/sql packages?
What is an invalid partition table?
How to return an array from java to pl/sql?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
Explian rowid, rownum? What are the psoducolumns we have?
What is sql character function?
what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...
What are the commands used in sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)