Re: SQL+ question

"dean" <deanbrown3d_at_yahoo.com> wrote in news:1149363216.064486.163250 @y43g2000cwc.googlegroups.com:

> Hello all,
>
> 9.2i/10g on Windows.
>
> I use select statements in an application, which use bind variables.
> Sometimes I like to take a look at the result set by inspecting the sql
> string in the code at runtime and then pasting it into sql+. But I have
> to declare and assign the variables before I can run it:
>
> var Col1 number;
> exec :Col1 := 1234;
> select * from T where Col1 = :Col1;
>
> Is there a short cut to this? Is it possible to use 'USING' (or
> something else) here and not declare the variables?
>
> Thanks all,
>
> Dean
>
>

Did you ever bother to try something like the following:

select * from T where Col1 = 1234; Received on Sat Jun 03 2006 - 14:40:49 CDT