ORALCE obtains the hostname and IP address

test · Posted on 1/24/2015 1:05:15 PM

In database application development and management, it is often necessary to obtain hostname and IP address information, which are related to environment variables and related data dictionaries

Method 1: Get it with a function SYS_CONTEXT

Use the attribute parameters SYS_CONTEXT the function to return the name and IP address of the current session host
• Terminal------------ usually refers to the name of the client
• Host---------------- the full name of the client
• ip_address--------- the IP address of the client
•server_host-------- the name of the server running the database instance
[mw_shl_code=sql,true] SELECT SYS_CONTEXT('USERENV','TERMINAL') AS 'Client Name' FROM DUAL
2
3SELECT SYS_CONTEXT('USERENV','HOST') AS 'Full Name of the Client' FROM DUAL
4
5SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') AS "Client's IP" FROM DUAL
6
7 - If there is no client connection, the result is displayed as empty
8SELECT SYS_CONTEXT('USERENV','server_host') FROM DUAL[/mw_shl_code]

[Communication] ORALCE obtains the hostname and IP address

Related Posts

Sections viewed