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