Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Query parameters
Markus Janscha wrote:
>
> Hey there,
>
> I am trying to create three independent queries, all stored in one *.sql
> file, that do something after the user enters one parameter at run time.
> The accept command does not work because the buffer is cleared after
> completion of the first select statement.
> The only solution I can think of is to insert the user's choice into a dummy
> table and then retrieve it for the subsequent queries.
>
> Is there a better way of doing this?
>
> Many thanks
>
> Markus
Put it in a shell wrapper. Received on Tue Dec 14 1999 - 06:49:09 CST
![]() |
![]() |