KyaPoocha.com

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 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 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...