内容
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)