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 online transaction processing (oltp)? : Sql dba
Can We write bulk collect statement in triggers?
What is posting?
What is dialect in sql?
Explain the steps needed to create the scheduled job?
What does joining a thread mean?
Can cursors be part of a trigger body?
What are all the different types of indexes?
what is explain plan?
How does sql*loader handles newline characters in a record? : aql loader
Is sql a oracle?
When is a declare statement required?
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)