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 |
Why commit is not used in triggers?
how to dump a table to a file with 'mysqldump'? : Sql dba
write the Sql query for creating database backup?
Does sql profiler affect performance?
what command is used to create a table by copying the structure of another table including constraints ?
what are pl/sql collections?
4 Answers JPMorgan Chase, Oracle,
How to call the function and Procedure in trigger?
Why stored procedure is better than query?
How to trace the errors in pl/sql block code?
What are the packages in pl sql?
Does db2 use sql?
What does varchar include?
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)