Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: find disconnected sessions

Re: find disconnected sessions

From: Thomas Niering <thomas.niering_at_arcor.de>
Date: 17 Jan 2003 06:55:00 +0200
Message-ID: <8e3512U2XzB.thomas.niering@arcor.de> 






Hallo Hartmut,



> but I get many rows from this statement with LOGON_TIME '16.01.03'

> when select sysdate from dual is 16.01.03.




Delete the dual-Table from your select, and it will work fine...
(The pseudo-dual-Table ist not necessary for the use with sysdate)



Ciao Thomas
Received on Thu Jan 16 2003 - 22:55:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US