Oops, should be: select SUBSTRING(machine, INSTRING(machine, '\') + 1) from v$session where sid=41; sorry, Igor Neyman On Thu, May 20, 2010 at 11:06 AM, Igor Neyman <igor.neyman@xxxxxxxxx> wrote: > 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 > > >