Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Selecting variables into functions
If I have a function:
select F_21_DAY_CALC(to_date('15-Dec-2004', 'dd-Mon-yyyy'), 'PETER', 21) from dual
how can I change my variables to select from a temporary table instead? I.E.
select F_21_DAY_CALC(select todate from temp), (select name from temp), (select number from temp) from dual
TIA
D
Received on Mon Apr 11 2005 - 13:33:05 CDT