A cursor references a result set. The REF CURSOR allows you to pass a cursor reference from one PL/SQL program unit to another. In other words, it allows you to create a variable that will receive a cursor and enable access to its result set,but in this blog I am giving examples for...
A cursor is a system memory space that is temporarily created while running a PL/SQL statement. The cursor stores a few sets of records named as the active set for executing an operation. In PL/SQL, you can have two types of cursors, i.e. implicit ...
As the name suggests Cursor For Loop is a type of For loop provided by oracle PL/SQL which makes working with cursors in oracle database a lot easier by executing OPEN, FETCH & CLOSE Cursor statements implicitly in the background for you....
In check time, the name is not known (not in all possibilities), and global cursor doesn't exist. It is significant break for any static analyse. PLpgSQL cannot to set correct type for record variables and cannot to check a dependent SQLs and expressions. A solution is same like dynamic...
PL/SQL Answer First Prev Next Last Showing Answers 1 - 5 of 5 Answersharru Dec 12th, 2011 If select query is retrieving less than 200 records go for implicit cursor. Code begin for i in (select * from emp) --- endElse use explicit cursor Code declare cursor c1 is select * fr...