For these kind of questions you're better off at an Oracle mailing list. Have a look e.g. at http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:210612357425 for an answer to your question.
Mind you, the result can be a monster performance-wise. Regards, Sven >----- Oorspronkelijk bericht ----- >Van: puneet arya [mailto:[EMAIL PROTECTED] >Verzonden: woensdag, juni 21, 2006 08:15 AM >Aan: [email protected] >Onderwerp: Re: how to use IN CLAUSE > >ya that is working for single value when we used in stored procedure and once >i know how to pass it there is no difficult it to relate t iBATIS. > Puneet Arya > >"Sven.Boden" <[EMAIL PROTECTED]> wrote: > >Funny, asking a question you answered yesterday: >http://www.mail-archive.com/[email protected]/msg04646.html > >This is also completely iBATIS unrelated. > >Regards, >Sven > > >>----- Oorspronkelijk bericht ----- >>Van: puneet arya [mailto:[EMAIL PROTECTED] >>Verzonden: woensdag, juni 21, 2006 07:59 AM >>Aan: [email protected] >>Onderwerp: how to use IN CLAUSE >> >>Hi, >> How to use IN CLAUSE in a stored procedure . i want to pass multiple values >> through IN CLAUSE in stored procedure. >> so how to pass it like select * from tablename where column name in (comma >> separated values). >> if any body know the solution plz tell its urgent. >> Puneet Arya >> >> >> >>--------------------------------- >> Yahoo! India Answers: Share what you know. Learn something new Click here >> Send free SMS to your Friends on Mobile from your Yahoo! Messenger Download >> now > > > > > >--------------------------------- > Yahoo! India Answers: Share what you know. Learn something new Click here > Send free SMS to your Friends on Mobile from your Yahoo! Messenger Download > now
