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 are the commands used in sql?
How to write html code in pl sql?
What is the reports view in oracle sql developer?
If we update a complex view, is base table will get update ?
2 Answers Ardee Technologies, HCL,
What is error ora-01000: maximum open cursors exceeded
what are date and time data types? : Sql dba
what are all the different normalizations? : Sql dba
What is difference between Procedures and Functions ?
What is self-join and what is the requirement of self-join?
what is subquery? : Sql dba
What is a natural join sql?
What is latest version of sql?