Re: parameters in query

You need to get a book that teaches your SQL, or read the one you have.

select * from order where id_order in (SELECT :id_order FROM ...)

"Tom" <mail_at_yahoo.com> wrote in message news:d331c9$6la$1_at_ss405.t-com.hr...
> i have lot of problems with letter query:
>
>
> select * from order where id_order in (1,5,9)
>
> oracle execute this query without problems, but
>
> select * from order where id_order in (:id_order)
>
> parametar is 1,5,9 oracle returns error
>
> any idea??
>
>
>
Received on Thu Apr 07 2005 - 05:37:33 CDT