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 int identity in sql?
What is cold data?
Is left join and outer join same?
What is dbo in sql?
what is 'mysqlcheck'? : Sql dba
What is cursor in pl sql with examples?
What is sql performance tuning?
If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??
what is a database lock ? : Sql dba
please explain database architecture..
what is the syntax for using sql_variant_property? : Transact sql
What is the purpose of a secondary key?
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)