SQL Plus - Prompt

About

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

Syntax

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

Support

Prompt suppress the first spaces

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

PROMPT                   Nico

will return

Nico

and not

                  Nico

One solution is to use the DBMS_OUTPUT.PUT_LINE function.

SET SERVEROUTPUT ON
SET FEEDBACK OFF
exec DBMS_OUTPUT.PUT_LINE( '                  Nico')

Powered by ComboStrap