oracle获得服务器,SQL获得ORACLE服务器端IP和客户端IP等各种信息

获取服务器的IP

SQL> set serverout on

SQL> exec dbms_output.put_line(utl_inaddr.get_host_address);

10.1.30.19

PL/SQL 过程已成功完成。

SQL> conn sqlexp/sqlexp@14

已连接。

SQL> exec dbms_output.put_line(utl_inaddr.get_host_address);

PL/SQL 过程已成功完成。

SQL> set serverout on

SQL> exec dbms_output.put_line(utl_inaddr.get_host_address); 10.1.30.14

PL/SQL 过程已成功完成。

SQL>

获取某个地址的IP

SELECT UTL_INADDR.get_host_address('http://www.doczj.com/doc/0810b95177232f60ddcca17c.html') from dual;获取客户端信息

select

SYS_CONTEXT('USERENV','TERMINAL') terminal,

SYS_CONTEXT('USERENV','LANGUAGE') language,

SYS_CONTEXT('USERENV','SESSIONID') sessionid,

SYS_CONTEXT('USERENV','INSTANCE') instance,

SYS_CONTEXT('USERENV','ENTRYID') entryid,

SYS_CONTEXT('USERENV','ISDBA') isdba,

SYS_CONTEXT('USERENV','NLS_TERRITORY') nls_territory,

SYS_CONTEXT('USERENV','NLS_CURRENCY') nls_currency,

SYS_CONTEXT('USERENV','NLS_CALENDAR') nls_calendar,

SYS_CONTEXT('USERENV','NLS_DATE_FORMAT') nls_date_format,

SYS_CONTEXT('USERENV','NLS_DATE_LANGUAGE') nls_date_language,