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 program will open a mdb file?
What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..
1 Answers Metric Stream, Polaris,
Will truncate release space?
What are aggregate and scalar functions?
What is left join in postgresql?
Does truncate release storage space?
What are the constraints available in sql?
suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how we will do..?
What is a full join?
function can return value ,procedure also return value through out parameter then what is the difference?
What is use of trigger?
What is pl sql in dbms?