can and open a ref cursor to have r

[Darshu]

can and open a ref cursor to have records for two conditions?
meaning
refc1 is my refcursor
if contition then
open refc1 for ----
else
open refc1 for --
end if
how can i do this and also
can i open ref cursor for insert statment and update statment
please give example

 

[Dagon]

Ref cursors aren't designed for update or insert statements but you can do these using syntax such as:

execute immediate 'update table_a set x=y where a=b';

You use ref cursors as follows:

declare
type t_curs is ref cursor;
v_curs t_curs;
begin
if condition1 then
open v_curs for 'select x,y,z from tablea';
else
open v_curs for 'select x,y,z from tableb';
end if;
end;