cursor open fetch close attributes %found, %notfound %isopen %rowco

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

Question Posted / vijay

Answer Posted / vijay

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Why use subqueries instead of joins?

1081

What packages(if any) has oracle provided for use by developers?

5811

What does trigger mean in psychology?

962

What are the different types of tables in sql?

1009

what is the difference between delete and truncate statement in sql? : Sql dba

1247

Enlist the data types that can be used in pl/sql?

1073

what is a database transaction? : Sql dba

1186

How do you update f as m and m as f from the below table testtable?

1859

What are different types of tables in sql?

998

Explain the structure of pl/sql in brief.

1095

Why partition by is used in sql?

1043

What is program debugging?

1256

How to fetch alternate records from a table?

1244

What is auto increment?

1001

Is foreign key mandatory?

1006