http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSQL_Plus%2FPrompt
Oracle PL/SQL/SQL Plus/Prompt - История изменений
2026-05-24T03:42:24Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.sqle.ru/index.php?title=Oracle_PL/SQL/SQL_Plus/Prompt&diff=1727&oldid=prev
в 13:45, 26 мая 2010
2010-05-26T13:45:19Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://www.sqle.ru/index.php?title=Oracle_PL/SQL/SQL_Plus/Prompt&diff=1728&oldid=prev
Admin: 1 версия
2010-05-26T09:58:48Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==PROMPT command outputs a line of data to the screen.==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL><br />
SQL> prompt<br />
SQL> prompt This is a list of users and their default<br />
This is a list of users and their default<br />
SQL> prompt tablespaces<br />
tablespaces<br />
SQL><br />
SQL> select username, default_tablespace<br />
2 from dba_users where rownum < 50;<br />
USERNAME DEFAULT_TABLESPACE<br />
------------------------------ ------------------------------<br />
SYS SYSTEM<br />
SYSTEM SYSTEM<br />
ANONYMOUS SYSAUX<br />
MDSYS SYSTEM<br />
OUTLN SYSTEM<br />
DIP SYSTEM<br />
TSMSYS SYSTEM<br />
FLOWS_FILES SYSAUX<br />
CTXSYS SYSAUX<br />
DBSNMP SYSAUX<br />
FLOWS_020100 SYSAUX<br />
USERNAME DEFAULT_TABLESPACE<br />
------------------------------ ------------------------------<br />
XDB SYSAUX<br />
HR USERS<br />
13 rows selected.<br />
SQL><br />
SQL><br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Set the prompt==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> --Set the prompt. Use predefined variables to access login<br />
SQL> --user name and net service name<br />
SQL> SET SQLPROMPT "&_user@&_connect_identifier(&database_name) >"<br />
sqle@XE(XE) ><br />
sqle@XE(XE) >SET TERMOUT ON<br />
sqle@XE(XE) ><br />
sqle@XE(XE) >SET FEEDBACK ON<br />
sqle@XE(XE) ><br />
sqle@XE(XE) ><br />
<br />
<br />
<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Use prompt to display information==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL><br />
SQL> prompt<br />
SQL> prompt This is a list of users and their default<br />
This is a list of users and their default<br />
SQL> prompt tablespaces<br />
tablespaces<br />
SQL><br />
SQL> select username, default_tablespace<br />
2 from dba_users<br />
3 where rownum < 50<br />
4 /<br />
USERNAME DEFAULT_TABLESPACE<br />
------------------------------ ------------------------------<br />
SYS SYSTEM<br />
SYSTEM SYSTEM<br />
ANONYMOUS SYSAUX<br />
MDSYS SYSTEM<br />
OUTLN SYSTEM<br />
DIP SYSTEM<br />
TSMSYS SYSTEM<br />
FLOWS_FILES SYSAUX<br />
CTXSYS SYSAUX<br />
DBSNMP SYSAUX<br />
FLOWS_020100 SYSAUX<br />
USERNAME DEFAULT_TABLESPACE<br />
------------------------------ ------------------------------<br />
XDB SYSAUX<br />
HR USERS<br />
13 rows selected.<br />
SQL><br />
SQL><br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Use prompt to output message==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL> prompt Please wait while data is inserted into class tables.<br />
SQL><br />
SQL><br />
<br />
<br />
<br />
<br />
</source></div>
Admin