get the computer name (without the domain name)?

  • From: Roger Xu <wellmetus@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 20 May 2010 10:03:24 -0500

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:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2010