Re: Optional Prompting for Parameters

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 15 Jun 2007 08:49:49 -0700
Message-ID: <1181922586.530140@bubbleator.drizzle.com>

EscVector wrote:

> 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.

Don't go crazy ... it was accidentally dropped by someone doing maintenance. Go here instead:
http://www.oracle.com/pls/db102/search?remark=quick_search&word=ACCEPT&tab_id=&format=ranked

and I will try to get it fixed.

-- 
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 Fri Jun 15 2007 - 10:49:49 CDT