Re: pl/sql question
From: Scott Urman <surman_at_oracle.com>
Date: 1996/06/20
Message-ID: <4qck8v$70o_at_inet-nntp-gw-1.us.oracle.com>#1/1
Date: 1996/06/20
Message-ID: <4qck8v$70o_at_inet-nntp-gw-1.us.oracle.com>#1/1
In article <31C5AC13.69EC_at_vistachrome.com>, Jennifer Brickner <brickner_at_vistachrome.com> writes:
|> Dear Starcrusher:
|>
|> You can use the accept statement. Below is an example.
|>
|> accept tabowner char prompt 'Table Owner: ';
|> accept tabname char prompt 'Table Name: ';
|> accept incltab char prompt 'Include TABLE definition? (Y/N): '
|>
|> Regards,
|> Jennifer
Just to be complete here, the accept command is valid only in SQL*Plus.
It isn't part of PL/SQL and wouldn't work if you were using PL/SQL from another
tool, such as Pro*C.
-- ------------------------------------------------------------------------ Scott Urman Oracle Corporation surman_at_us.oracle.com ------------------------------------------------------------------------ Author of _Oracle PL/SQL Programming_ ISBN 0-07-882176-2 Published by Oracle Press - http://www.osborne.com/oracle/index.htm ------------------------------------------------------------------------ "The opinions expressed here are my own, and are not necessarily that of Oracle Corporation" ------------------------------------------------------------------------Received on Thu Jun 20 1996 - 00:00:00 CEST