Declare type rc is ref cursor; cursor c is select * from dual; l_cursor rc; begin if ( to_char(sysdate,'dd') = 30 ) then open l_cursor for 'select * from emp'; elsif ( to_char(sysdate,'dd') = 29 ) then open l_cursor for select * from dual; end if; open c; end; /Note: The regular will only select data from dual, whereas the ref cursor can be opened using multiple cursors.
For more information see Brian Peasland's article on SearchOracle.com dated 23 December 2002, titled "REF cursors explained."
Dig deeper on Oracle and SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.