RE: get the computer name (without the domain name)?
- From: "Sweetser, Joe" <JSweetser@xxxxxxxx>
- To: <igor.neyman@xxxxxxxxx>, <wellmetus@xxxxxxxxx>
- Date: Thu, 20 May 2010 09:09:50 -0600
Or, better still, what Igor said! J
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Igor Neyman
Sent: Thursday, May 20, 2010 9:07 AM
To: wellmetus@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: get the computer name (without the domain name)?
Try:
select SUBSTRING(machine, INSTRING('\') + 1) from v$session where
sid=41;
Igor Neyman
On Thu, May 20, 2010 at 11:03 AM, Roger Xu <wellmetus@xxxxxxxxx> wrote:
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:
