What are the PL/SQL Statements used in cursor processing ?

Answers were Sorted based on User's Feedback



What are the PL/SQL Statements used in cursor processing ?..

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

What are the PL/SQL Statements used in cursor processing ?..

Answer / chandrasekar

Select,for loop

Is This Answer Correct ?    3 Yes 1 No

What are the PL/SQL Statements used in cursor processing ?..

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

What are the PL/SQL Statements used in cursor processing ?..

Answer / vijay

cursor
open
fetch
close
attributes
%found,
%notfound
%isopen
%rowcount
loop
whlie loop
for loop

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Two Methods of retrieving SQL?

7 Answers   Atiric Software, Microsoft, Oracle, TCS, Wipro,


What is Difference between StoredProcedure and function?

3 Answers  


Define SQL and state the differences between SQL and other conventional programming Languages?

0 Answers  


How to remove duplicate rows from a table?.

3 Answers  


Explain character-manipulation functions?

0 Answers  






Explain alias in sql?

0 Answers  


What are sql constraints?

0 Answers  


Can I create table without primary key?

0 Answers  


What are aggregate functions in sql?

0 Answers  


what is the output of this query selet * from employee where 1=2 ??

11 Answers  


What is the basic structure of PL/SQL ?

6 Answers  


What is %type in pl sql?

0 Answers  


Categories