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 |
Two Methods of retrieving SQL?
7 Answers Atiric Software, Microsoft, Oracle, TCS, Wipro,
What is Difference between StoredProcedure and function?
Define SQL and state the differences between SQL and other conventional programming Languages?
How to remove duplicate rows from a table?.
Explain character-manipulation functions?
Explain alias in sql?
What are sql constraints?
Can I create table without primary key?
What are aggregate functions in sql?
what is the output of this query selet * from employee where 1=2 ??
What is the basic structure of PL/SQL ?
What is %type in pl sql?