RE: get the computer name (without the domain name)?

If the domain name is always the same, I think you could use the substr
function.

 

-joe

 

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Roger Xu
Sent: Thursday, May 20, 2010 9:03 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: get the computer name (without the domain name)?

 

Hi expert,
 
How can I only get the computer name (without the domain name)?
 
SQL> select machine from v$session where sid=41;
MACHINE
--------------------
Domain1\BB011499
SQL>
 
 
In UNIX, I would do this but I need it to be done inside SQL
 
# echo 'Domain1\BB011499' | awk -F\\ '{print $NF}'
BB011499
 
Thanks,
 
Roger Xu 

Other related posts: