I have Oracle 9i.I’m absolutely beginner and making simple queries is OK, but this seem to me very complicated. So I want to do it step by step to follow up this problem. The first step is that I want to query the table below and to get as result the time_stamp and the point_name of those points which last status was Disable.
TIME_STAMP POINT_NAME STATUS
10/03/2007 12:00:01 AX025_W ENABLE
28/05/2006 12:34:11 DGM403F DISABLE
28/05/2006 11:12:45 DGMH403 DISABLE
28/05/2006 09:10:23 DGMI403 DISABLE
28/05/2006 09:22:12 DGMI403 ENABLE
28/05/2006 22:11:26 DGMI403 DISABLE
29/05/2006 01:00:03 DGMI403 ENABLE
18/05/2006 11:00:22 XAC001 INHIBIT
10/03/2006 22:45:23 XACC003 DISABLE
29/01/2006 10:53:22 XA104 DISABLE
30/11/2006 15:37:21 XA106 DISABLE
I already did it. The second state is to get the period for which points were disabled. If they are still disabled the end of the period will be Now. So can anybody help me
