CREATE TABLE Ticker (SYMBOL VARCHAR2(10), tstamp DATE, price NUMBER)

INSERT INTO Ticker VALUES('ACME', '01-Apr-11', 12)

INSERT INTO Ticker VALUES('ACME', '02-Apr-11', 17)

INSERT INTO Ticker VALUES('ACME', '03-Apr-11', 19)

INSERT INTO Ticker VALUES('ACME', '04-Apr-11', 21)

INSERT INTO Ticker VALUES('ACME', '05-Apr-11', 25)

INSERT INTO Ticker VALUES('ACME', '06-Apr-11', 12)

INSERT INTO Ticker VALUES('ACME', '07-Apr-11', 15)

INSERT INTO Ticker VALUES('ACME', '08-Apr-11', 20)

INSERT INTO Ticker VALUES('ACME', '09-Apr-11', 24)

INSERT INTO Ticker VALUES('ACME', '10-Apr-11', 25)

INSERT INTO Ticker VALUES('ACME', '11-Apr-11', 19)

INSERT INTO Ticker VALUES('ACME', '12-Apr-11', 15)

INSERT INTO Ticker VALUES('ACME', '13-Apr-11', 25)

INSERT INTO Ticker VALUES('ACME', '14-Apr-11', 25)

INSERT INTO Ticker VALUES('ACME', '15-Apr-11', 14)

INSERT INTO Ticker VALUES('ACME', '16-Apr-11', 12)

INSERT INTO Ticker VALUES('ACME', '17-Apr-11', 14)

INSERT INTO Ticker VALUES('ACME', '18-Apr-11', 24)

INSERT INTO Ticker VALUES('ACME', '19-Apr-11', 23)

INSERT INTO Ticker VALUES('ACME', '20-Apr-11', 22)

SELECT * 
FROM Ticker MATCH_RECOGNIZE ( 
     PARTITION BY Symbol 
     ORDER BY tstamp 
     MEASURES  
              CLASSIFIER() AS Classfr, 
              MATCH_NUMBER() AS Matchno, 
							FINAL LAST(b.tstamp) AS last_b 
     ALL ROWS PER MATCH 
     AFTER MATCH SKIP TO LAST B 
     PATTERN ( STRT A B+ ) 
     DEFINE 
        A AS A.Price >= 1 
        ,B AS B.Price > PREV(B.Price) 
)  M 
ORDER BY symbol, tstamp