10. Find connected session,login_time in a given time

SELECT
a.sid,a.serial#,a.username,a.osuser,a.machine
,a.service_name
,to_char(a.logon_time, 'hh24:mi dd/mm/yy') login_time
FROM
v$session a,v$process b
WHERE
a.username IS NOT NULL
AND
a.paddr=b.addr
AND a.type='USER'
AND a.logon_time > to_date ('2008-10-18 15:00:00','YYYY-MM-DD HH24:MI:SS')
AND a.logon_time < to_date ('2008-10-19 15:00:00','YYYY-MM-DD HH24:MI:SS')
Order by a.sid,a.username;