Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Query parameters

Re: Query parameters

From: Kenneth C Stahl <BlueSax_at_Unforgettable.com>
Date: Tue, 14 Dec 1999 07:49:09 -0500
Message-ID: <38563CC5.48C18E17@Unforgettable.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US