OraQA

Oracle Question and Answer

Frank Zhou:
Gmyers, Your simpler method doesn’t work, it didn’t put all cases into consideration. For...
gmyers:
Or a simple select str_num, case when length(replace(str_num, ’)')) = length(replace(str_n...
stewstryker:
Latest version is 3.1. Man, this thread is old!
prashant.pawar:
I could able to resolve this issue. my files under $ORACLE_HOME/network/me sg/ were corrupted. copied...

Comments RSS feed

Do you have a solution to a problem? Do you have an unanswered question? Login and share it with the Oracle community. More...

January 16th, 2006 By smnair

select host_name from v$instance;

pass the host name to this second query to return the IP address:

select UTL_INADDR.get_host_address('host name') from dual ;

Filed under Administration, SQL. Follow any responses to this entry through this RSS 2.0 feed.

You must be logged in to post a comment.