SQL* Plus CLI  «Prev 

Syntax for PROMPT and ACCEPT

SQL Plus accept prompt
  1. PROMPT commands: The PROMPT commands display a message reminding the user about what the script does.
  2. ACCEPT user_name: The ACCEPT command allows the user to type in a username.
  3. PROMPT: What user are you interested in? This is the prompt that the ACCEPT command uses.
  4. &user_name: This text will be replaced by the username that is typed in when the script is run.