Re: parameters in query

On Thu, 07 Apr 2005 14:52:03 +0200, Tom interested us by writing:

> 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!!
>

Now you are seeing that TOAD != SQL*Plus

You want substitution variables, not bind variables, for this particular situation. Bind variables work at the database level (they are the ones with :), whereas substitution variables are tool based and TOAD's implementation is much different that SQL*Plus.

Consider also checking the TOAD site and FAQ for help. Received on Thu Apr 07 2005 - 08:24:33 CDT