3

More than 5 years have passed since last update.

TIS株式会社

Oracleで接続元マシンのIPアドレスを取得する

oracle

Posted at 2014-01-06

SELECT SYS_CONTEXT('USERENV', 'IP_ADDRESS') AS IP_ADDRESS FROM DUAL;

実行結果

IP_ADDRESS
--------------
192.168.1.21

参考

ＯＲＡＣＬＥ／オラクルＳＱＬリファレンス（SYS_CONTEXT）

他にも色々取れるっぽい。

3

Register as a new user and use Qiita more conveniently

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up

3