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

From: Igor Neyman <igor.neyman@xxxxxxxxx>
To: wellmetus@xxxxxxxxx
Date: Thu, 20 May 2010 11:06:55 -0400

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

Follow-Ups:

Re: get the computer name (without the domain name)?
From: Igor Neyman

RE: get the computer name (without the domain name)?
From: Sweetser, Joe

Re: get the computer name (without the domain name)?
From: Roger Xu

References:
- get the computer name (without the domain name)?
  - From: Roger Xu

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

Other related posts: