Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Optional Prompting for Parameters
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.orgReceived on Thu Jun 14 2007 - 15:44:29 CDT
![]() |
![]() |