SQL Plus - Prompt

> Procedural Languages > (SQL Plus|SqlCl) (Oracle Database Console)

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

Advertising

3 - Syntax

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

4 - Support

4.1 - 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')
lang/sqlplus/prompt.txt · Last modified: 2017/09/06 22:18 by gerardnico