René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

ACCEPT [SQL*Plus]

accept variable

accept variable number
accept variable char
accept variable date
accept variable binary_float
accept variable binary_double

accept variable format format-string

accept variable default default-value

accept variable prompt prompt-string
accept variable noprompt

accept variable hide
With accept, it is possible to interactively set a value for a user variable in SQL*Plus.
accept foo prompt 'Enter value for foo'

Inputting passwords

accept pw prompt 'Enter your secret password' hide