Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Selecting variables into functions

Selecting variables into functions

From: <dsolly_at_gmail.com>
Date: 11 Apr 2005 11:33:05 -0700
Message-ID: <1113244385.097094.287100@g14g2000cwa.googlegroups.com> 





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












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US