Oracle Dynamic Cursor

Oracle Dynamic Cursor

Declarev_col1 varchar2 (254); v_col2 varchar2 (254); v_ SQL varchar2 (1024); type my_cursor is ref cursor; v_cur my_cursor; beginv_ SQL: = 'select: 1 ,: 2 from dual where 1 =: 3'; open v_cur for v_sqlusing 'col1', 'col2', 1; loopfetch v_curinto v_col1, v_col2; exit when v_cur % notfound; dbms_output.put_line (v_col1 | ''| v_col2); end loop; close v_cur; end;

Explicit Cursor attributes include:

Attribute Return Value Type of the cursor meaning % ROWCOUNT integer get the number of data rows returned by the FETCH Statement % FOUND the most recent FETCH statement returns a row of data to true, otherwise, the value is false. % NOTFOUND: opposite to the value returned by the % FOUND attribute. % ISOPEN: the value of the Boolean cursor is true. Otherwise, the value is false.