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 |
How can you get sql*loader to commit only at the end of the load file? : aql loader
What is materialised View?
Which data type is a composite type?
What is not null in sql?
What is the max nvarchar size?
How insert into statements in sql?
What is the difference between pl and sql?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
What is normalisation in sql?
Is truncate ddl or dml?
in materialized view the structure will create immediately or not?
What is the main difference between sql and pl/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)