Forum Moderators: open

Message Too Old, No Replies

Passing Multiple values into a simple SQL function?

         

rotfil

10:20 am on May 30, 2008 (gmt 0)

10+ Year Member



I have a function called dt_process_customer and I need to pass maybe 5 customer IDs into an SQL statement.. I think the statement should look something like the below bu ti am not sure.

select dt_process_customer in (233, 322) as one from dual

wingnut

4:07 pm on May 30, 2008 (gmt 0)

10+ Year Member



Select dt_process_customer From tablename Where dt_process_customer in (233, 322)