Re: Oracle-Advanced SQL-question

From: Ed Prochak <ed.prochak_at_magicinterface.com>
Date: 9 Jun 2005 11:12:43 -0700
Message-ID: <1118340763.114806.216060@g49g2000cwa.googlegroups.com>

my impression was that logout should be part of the same row. IOW inster of a table with columns like:

CIDUSER CTIMESTAMP CSUBJECT

17           2005-06-06     LOGIN
17           2005-06-06     LOGOUT

the columns should be

CIDUSER CTIMESTART CSUBJECT CTIMEFINISH

17           2005-06-06     LOGIN           2005-06-06
27           2005-06-06     LOGIN

so the first user (17) ended his session but the second user (27) did not end her session.
Sometimes convoluted queries just indicate opportunities to improve the data model.

Ed Received on Thu Jun 09 2005 - 13:12:43 CDT