What happens when you say OPEN CURSOR ?
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.
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
Can you have more than one cursor open at any one time in a program ? 28.07.08
Yes....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 are savepoint mode and cursor mode properties ? level? 06.05.08
Specifies whether Oracle Forms should issue savepoints during a session. This property is included primarily for applications that will run against non-ORACLE d...When is the results table for the query in a DECLARE CURSOR statement created ? 10.04.08
The results table for a query specified in a DECLARE CURSOR statement of a cursor is created during the execution of the OPEN CURSOR statement....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 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 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...