The ACCEPT Command

From: SJWNet <scottjw_at_my-deja.com>
Date: Fri, 01 Oct 1999 19:20:42 GMT
Message-ID: <7t31hr$dgn$1@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 Fri Oct 01 1999 - 14:20:42 CDT