thx sevan ,
     i am able to achieve it through the link u have sent. but y have written like that "Mind you, the result can be a monster performance-wise."
what will be the consequences on using this .
  Regards,
 Puneet Arya                                         

"Sven.Boden" <[EMAIL PROTECTED]> wrote:

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




Yahoo! India Answers: Share what you know. Learn something new Click here

Reply via email to