What is the significance of the CURSOR WITH HOLD clause in a cursor declaration ?
The clause avoids closing the cursor and repositioning it to the last row processed when the cursor is reopened.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What happens when you say OPEN CURSOR ? 28.07.08
If there is an ORDER BY clause, rows are fetched, sorted and made available for the FETCH statement. Other wise simply the cursor is placed on the first row....Difference between an implicit & an explicit cursor? 11.05.08
PL/SQL declares a cursor implicitly for all SQL data manipulation statements, including quries that return only one row. However,queries that return more than o...What is use of a cursor variable? How it is defined 11.05.08
A cursor variable is associated with different statements at run time, which can hold different values at run time. Static cursors can only be associated with o...How you open and close a cursor variable.Why it is required? 11.05.08
OPEN cursor variable FOR SELECT...Statement CLOSE cursor variable In order to associate a cursor variable with a particular SELECT statement OPEN syntax is used...What is read-only cursor ? 10.04.08
A read-only cursor is one in which the result table was created by a query containing one of the following : • a DISTINCT keyword • a UNION o...How do you leave the cursor open after issuing a COMMIT ? 12.03.08
Use WITH HOLD option in DECLARE CURSOR statement. But, it has not effect in psuedo-conversational CICS programs....What is get cursor field? 18.03.07
GET CURSOR statement transfers the name of the screen element on which the cursor is positioned during a user action into the variable . GET CURSOR FIELD [O...How you were passing cursor variables in PL/SQL 2.2 ? 16.03.06
In PL/SQL 2.2 cursor variables cannot be declared in a package.This is because the storage for a cursor variable has to be allocated using Pro*C or OCI with ver...Can we get the x and y coordinate of the current cursor position ? 12.03.06
The function wherex( ) and wherey( ) returns the x-coordinate and y-coordinate of the current cursor position respectively. Both the functions return an integer...How do I change the type of cursor and hide a cursor? 12.03.06
We can change the cursor type by using function _setcursortype( ). This function can change the cursor type to solid cursor and can even hide a cursor. Followin...