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

Home -> Community -> Usenet -> c.d.o.server -> how do u compare timestamps on different rows that are related to same event

how do u compare timestamps on different rows that are related to same event

From: hourman <sdfdfwetudfyt_at_7fdfster.com>
Date: 8 Jun 2004 19:56:14 -0500
Message-ID: <40c65f71$0$52008$45beb828@newscene.com>


Oracle 9i on Sun Unix on Sun Star server

a batch process runs every 6 hours. its composes of 10 stored procedures that run one after another assuming prior one finished ok. each procedure logs when it started and when it ended. total takes 20-30 minutes but sometimes 1-2 hours.

we have following table

event name                      date

web login start                 7/1/04 9:24:14
web update start                      7/1/04 9:24:36
web update end                      7/1/04 9:28:40
web insert start                       7/1/04 10:34:15
web insert end                      7/1/04 10:45:14
web login end                       7/1/04 10:49:22

web login start                 7/1/04 15:24:14
web update start                      7/1/04 15:25:36 ....

what we want to see is following

event start event end total time

web login start         web login end       1:25:08
webupdate start        web update end    0:4:23  etc
.

and 2nd batch 6 hours later

web login start         web login end       1:25:08
webupdate start        web update end    0:4:23  etc


we want the ones related to each other in each batch

is this possible?       Received on Tue Jun 08 2004 - 19:56:14 CDT

Original text of this message

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