Help on Oracle SQL query

From: Miguel Camba <M.CAMBA_at_terra.es>
Date: Sun, 20 Jan 2002 01:21:31 GMT
Message-ID: <3c4a1af6.15924746_at_news.terra.es>

I have an Oracle 8.1.6 table PURCHASEORDERST

CHANGEDATE DATE
PURCHASEORDER VARCHAR2(20)

STATUS                      VARCHAR2(2)

Primary key on (CHANGEDATE, PURCHASEORDER)

When purchase order status change a trigger insert a record in PURCHASEORDERST table.

V1, V2 are valid status; N1, N2 are not valid status (for other application)

Later, I got a date like a parameter; I need to know if the last status before the parameter is a valid status or not.

What is the better SQL query?

Thanks. Received on Sun Jan 20 2002 - 02:21:31 CET