PROMPT command outputs a line of data to the screen. : Prompt « SQL Plus « Oracle PL / SQL






  1. Oracle PL / SQL
  2. SQL Plus
  3. Prompt

PROMPT command outputs a line of data to the screen.

  
SQL>
SQL>
SQL> prompt

SQL> prompt This is a list of users and their default
This is a list of users and their default
SQL> prompt tablespaces
tablespaces
SQL>
SQL> select username, default_tablespace
  2    from dba_users where rownum < 50;

USERNAME                       DEFAULT_TABLESPACE
------------------------------ ------------------------------
SYS                            SYSTEM
SYSTEM                         SYSTEM
ANONYMOUS                      SYSAUX
MDSYS                          SYSTEM
OUTLN                          SYSTEM
DIP                            SYSTEM
TSMSYS                         SYSTEM
FLOWS_FILES                    SYSAUX
CTXSYS                         SYSAUX
DBSNMP                         SYSAUX
FLOWS_020100                   SYSAUX

USERNAME                       DEFAULT_TABLESPACE
------------------------------ ------------------------------
XDB                            SYSAUX
HR                             USERS

13 rows selected.

SQL>
SQL>








Related examples in the same category

1.Use prompt to display information
2.Set the prompt
3.Use prompt to output message