SQL Plus - Prompt

Card Puncher Data Processing


Prompt is an command that sends the specified message or a blank line to the user's screen.

You can control its behaviour with the TERM system variable


PRO[MPT] [text]
  • Using two semicolons caused a single semicolon to be displayed


Prompt suppress the first spaces

The PROMPT command suppress the spaces at the beginning of the text

PROMPT                   Nico

will return


and not


One solution is to use the DBMS_OUTPUT.PUT_LINE function.

exec DBMS_OUTPUT.PUT_LINE( '                  Nico')

Discover More
Card Puncher Data Processing
SQL Plus - ACCEPT command (Console Interaction)

The accept command reads a line of input and stores it in a given substitution variable. where: variable is the variable command prompt is the prompt command HIDE will hide the input For...
Card Puncher Data Processing
SQL Plus - Command Reference

Commands Description @ @@ / ACCEPT APPEND ARCHIVE ATTRIBUTE BREAK BTITLE CHANGE CLEAR COLUMN COMPUTE CONNECT COPY Copies data from a query to a table in the same or another...
Card Puncher Data Processing
SQL Plus - Print (Bind Variables)

Print is a command that displays the current values of bind variables, or lists all bind variables. PROMPT
Card Puncher Data Processing
SQL Plus - Substitution Variables

You can define variables, called substitution variables, for repeated use in a single script. Note that you can also define substitution variables to use in titles and to save your keystrokes (by defining...

Share this page:
Follow us:
Task Runner