Edited at

sqlplusで接続情報などを確認する方法 (def)

More than 1 year has passed since last update.


内容

sqlplusで接続にdefと入力すると、SIDやユーザなどを確認できる。


確認

▼コマンド

SQL> def

▼結果

DEFINE _DATE           = "16-09-06" (CHAR)

DEFINE _CONNECT_IDENTIFIER = "##SID##" (CHAR)
DEFINE _USER = "SYS" (CHAR)
DEFINE _PRIVILEGE = "AS SYSDBA" (CHAR)
DEFINE _SQLPLUS_RELEASE = "1201000200" (CHAR)
DEFINE _EDITOR = "ed" (CHAR)
DEFINE _O_VERSION = "Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
and Unified Auditing options"
(CHAR)
DEFINE _O_RELEASE = "1201000200" (CHAR)