Re: SQL*Plus Question

From: Ed_Zep <ed_zep_at_ntlworld.com>
Date: 9 Jun 2006 04:02:22 -0700
Message-ID: <1149850942.527284.132720@i40g2000cwc.googlegroups.com>

Thanks to both of you for the replies.

Regards, Ed.

Ed_Zep wrote:
> This should be easy but...
>
> I'm trying to get a list from v$session of users logged in more than
> once with the same username but on different machines.
>
> I can do:
>
> select logon_time, username, osuser, machine, count(1) from v$session
> group by logon_time,username, osuser, machine
> having count(1) > 1
>
> but this will only give me one line per user. I need to see the same
> username, etc for say "JSMITH" 3 times if he's logged in three times on
> different machines...
>
> I'd like to exclude rows where the user is logged on twice on the same
> machine.
>
> Many thanks,
>
> Ed.
Received on Fri Jun 09 2006 - 06:02:22 CDT