Re: Assigning value from one cursor to another?

romich_at_dukascopy.com said...
> I have 2 cursors , one is opened for select, then if some condition is true
> i have to send c1.value to c2.?
> Can I?
>

Do you mean something like this?

declare
  cursor c2 (c1_value in number) is select...;   ...declare "into" variables...
begin
  for c1 in (select ...)
  loop
    open c2 (c1.value);
    fetch c2 into...;
    ...do something...
    close c2;
  end loop;
end;

-- 
/Karsten
DBA > retired > DBA