Re: pl/sql question

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