Re: parameters in query

in sql plus i wrote

    select * from order where id_order in (&d_order) and input value of parameter 1,5,9 and it's ok!!

"Tom" <mail_at_yahoo.com> wrote in message news:d3397r$m4c$1_at_ss405.t-com.hr...
>I need suptitution of bind variables...
>
> i'm runnig query in T.O.A.D so after execution query
> select * from order where id_order in (:id_order)
> in variable window i pick in Type box Substitution (instead of String) and
> in Value box i type 1,5,9
> query execute right!!!!
> but how did i run this query throug sqlplus or other program
> through sqlplus i wrote:
>
> variable id_order number
> /
> exec :id_order := 1
> /
> select * from order where id_order in (:id_order)
> sql returns only id_order = 1
>
> i think that problem is maybe with declaration of bind variable...
>
>
> "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 - 07:52:03 CDT