Hi list,
I'd like to use the result of one SQL as the input of the second SQL. I
tried to use bind variable but it does not work.
--
clear buffer
input
select fnfno,fnnam from x$kccfn where fnnam like '%&1%.dbf'

save proc1 replace

variable myvar varchar2(5);
select to_char(sysdate,'monyy') into :myvar from dual; ==> This SQL does
not append a value into bind variable :myvar

start proc1 :mthyy
--
What am I doing wrong Or is there other way doing this ?

Thanks for your help.

Hai-Thuy Nguyen



Oracle LazyDBA home page