Problem faced with v$session and Concat !!

[meeradevi]

I want to net send a message to logged on users:

select distinct 'net send ' || substr(machine,instr(machine,'\')+1) || ' This is a test' ,machine from v$session
where terminal is not null


If my machine name is "ABC\MEERA" I expect the outpout to be "net send MEERA This is a test"

but I am getting "net send MEERA" only.

But if the machine name is "RAAJI" without "\" , I am getting the expected result "net send RAAJI This is a test"

How do I overcome this issue ?

 

[SantaMufasa]

Meeradevi,

My exact copy and paste of your code works fine (as expected) on my machine. Could you please do a copy and paste from your screen of both the code (as it runs from SQL*Plus) and the resulting output? Then perhaps we can be of more assistance.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[meeradevi]

Hi Santa....you are back !! )

I have copied the exact code from my machine but the only difference is that the machine names in the actual database are bigger (for example) : CDT\BNSEN9238743

 

[SantaMufasa]

Thanks (I was out to a meeting this afternoon.)

So, could you please paste the exact display of your code and the output from your SQL*Plus session? It's not that I don't believe what you are saying...I just need to see what I've requested, if that works for you.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.