When you COMMIT, is the cursor closed ?
Yes.
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 is use of COMMIT option in IMP command? 23.05.08
A flag to indicate whether import should commit after each array. If 'N' then commit will take place at table level....What is the difference between POST-DATABASE-COMMIT and POST-FORM-COMMIT? 20.05.08
POST-FORM-COMMIT fires once during the Post and Commit Transactions process, after the database commit occurs. The Post-Forms-Commit trigger fires after inserts...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...What is the significance of the CURSOR WITH HOLD clause in a cursor declaration ? 03.04.08
The clause avoids closing the cursor and repositioning it to the last row processed when the cursor is reopened....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 cursor stability ? 07.03.08
It is cursor stability that “tells” DB2 that database values read by this application are protected only while they are being used. (Changed values are...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...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...