Oracle PL/SQL/SQL Plus/Prompt
Содержание
PROMPT command outputs a line of data to the screen.
<source lang="sql">
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>
</source>
Set the prompt
<source lang="sql">
SQL> SQL> --Set the prompt. Use predefined variables to access login SQL> --user name and net service name SQL> SET SQLPROMPT "&_user@&_connect_identifier(&database_name) >" sqle@XE(XE) > sqle@XE(XE) >SET TERMOUT ON sqle@XE(XE) > sqle@XE(XE) >SET FEEDBACK ON sqle@XE(XE) > sqle@XE(XE) >
</source>
Use prompt to display information
<source lang="sql">
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 3 where rownum < 50 4 /
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>
</source>
Use prompt to output message
<source lang="sql">
SQL> prompt Please wait while data is inserted into class tables. SQL> SQL>
</source>