Re: how to use IN CLAUSE

[puneet arya]

hi,

 that iterate tag is to run the query when we are not using the stored procedure and that tag is reffered to IBATIS not to oracle.

my question is how to pass comma separated values in oracle while using IN clause.

                                Puneet arya

Larry Meadors <[EMAIL PROTECTED]> wrote:

Look at the iterate tag.

Larry


On 6/20/06, puneet arya <[EMAIL PROTECTED]>wrote:
>
> 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