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: Optional Prompting for Parameters

Re: Optional Prompting for Parameters

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 14 Jun 2007 13:44:29 -0700
Message-ID: <1181853867.301144@bubbleator.drizzle.com>


faceman28208_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 at www.psoug.org
Scroll down to SQL*Plus
Scroll down to ACCEPT

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Jun 14 2007 - 15:44:29 CDT

Original text of this message

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