Re: Optional Prompting for Parameters

On Jun 14, 4:44 pm, DA Morgan <damor..._at_psoug.org> wrote:
> faceman28..._at_yahoo.com wrote:
> > I would like to have an SQL script that will prompt for parameters
> > that are not given.
>
> > If I do
>
> > @test 10
>
> > it will run silently.
>
> > If i do
>
> > @test
>
> > It will respond
>
> > Enter Employee ID:
>
> > How might one do this?
>
> Go to Morgan's Library atwww.psoug.org
> Scroll down to SQL*Plus
> Scroll down to ACCEPT
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

I'm going crazy because I can't find the ACCEPT part.

reference/sqlplus.html

But no ACCEPT on the page. Received on Thu Jun 14 2007 - 21:42:13 CDT