Re: Help on Oracle SQL query

I'm not sure exactly what you are aiming for, but would a trigger that fires before the row insert work?

Miguel Camba wrote:
>
> 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 - 03:55:06 CET