I believe you have to run the code as a script. (ie: at the SQL> prompt,
type: @accept_sample.sql)
SJWNet <scottjw_at_my-deja.com> wrote in message
news:7t31hr$dgn$1_at_nnrp1.deja.com...
> From an Oracle Student Guide (Production 1.2 / Volume 1) the following
> code is listed:
>
> ACCEPT dept PROMPT 'Provide the department name: '
> SELECT *
> FROM dept
> WHERE dname = UPPER('&dept')
>
> The first line is entered, but then the prompt shows up immediately
> rather than allowing for the rest of the code to be entered and later
> executed as a whole block of code. Entering, for example, Sales at the
> prompt followed by a return ends the routine and the SQL> prompt is
> waiting for a new command.
>
> What is the trick to getting the ACCEPT command to work?
>
> --
> SJWNet
> NT Novice
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Oct 03 1999 - 12:54:21 CDT
