http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSQL_Plus%2Fdefine
Oracle PL/SQL/SQL Plus/define - История изменений
2026-04-06T13:43:07Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=Oracle_PL/SQL/SQL_Plus/define&diff=1691&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://sqle.ru/index.php?title=Oracle_PL/SQL/SQL_Plus/define&diff=1692&oldid=prev
Admin: 1 версия
2010-05-26T09:58:38Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Check pre-defined variables==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> def x<br />
DEFINE X = "7500" (CHAR)<br />
SQL> def<br />
DEFINE _DATE = "" (CHAR)<br />
DEFINE _CONNECT_IDENTIFIER = "XE" (CHAR)<br />
DEFINE _USER = "sqle" (CHAR)<br />
DEFINE _PRIVILEGE = "" (CHAR)<br />
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)<br />
DEFINE _EDITOR = "Notepad" (CHAR)<br />
DEFINE _O_VERSION = "Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production" (CHAR)<br />
DEFINE _O_RELEASE = "1002000100" (CHAR)<br />
DEFINE _RC = "0" (CHAR)<br />
DEFINE X = "7500" (CHAR)<br />
SQL> undefine x<br />
SQL><br />
<br />
<br />
<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==show define==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> show define<br />
define "&" (hex 26)<br />
SQL> show concat<br />
concat "." (hex 2e)<br />
SQL><br />
<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Using the Define Command==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
col segment_name for a27<br />
define owner = "&1"<br />
select segment_name,segment_type,extents from dba_segments where owner = upper ("&owner)<br />
and extents > 10 and segment_name not like "TMP%"<br />
order by segment_type,extetns desc<br />
@extents.sql<br />
<br />
<br />
</source></div>
Admin