Re: binding values in IN(:1, :2,:3)

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 31 Mar 2001 13:06:53 +0100
Message-ID: <986040261.6874.1.nnrp-12.9e984b29@news.demon.co.uk>

There is an article on my website about this - using version 8, though. Look under

miscellaneous -> in lists

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Rene Nyffenegger wrote in message <996as2$730$1_at_news1.sunrise.ch>...


>Hi

>

>I am trying to bind values in the IN clause of an SQL statement

>using OCI.

>

>select sth from stbl where sth_id in (:1, :2, :3)

>

>Almost needless to say that the count of parameters in the in clause

>varies.

>

>Can that be achieved and if yes: how

>

>tia

>

>Rene

>

>

>

Received on Sat Mar 31 2001 - 06:06:53 CST