CREATE  TABLE T29
(
    ID      VARCHAR2(20),
    des     VARCHAR2(20)
);

INSERT INTO T29 VALUES('1', 'GENERATE');
INSERT INTO T29 VALUES('2', 'SUBMIT');
INSERT INTO T29 VALUES('3', 'APPROVE');
INSERT INTO T29 VALUES('4', 'APPROVAL_REJECT');
INSERT INTO T29 VALUES('5', 'SUBMIT');
INSERT INTO T29 VALUES('6', 'APPROVE');
INSERT INTO T29 VALUES('7', 'APPROVE');
INSERT INTO T29 VALUES('8', 'APPROVAL_REJECT');
INSERT INTO T29 VALUES('9', 'SUBMIT');
INSERT INTO T29 VALUES('10', 'APPROVE');
INSERT INTO T29 VALUES('11', 'APPROVE');
INSERT INTO T29 VALUES('12', 'APPROVE');

------解决方案--------------------
SQL code
with t as (
select 'GENERATE'  a     from dual  union all 
select 'SUBMIT'          from dual  union all 
select 'APPROVE'         from dual  union all 
select 'APPROVAL_REJECT' from dual  union all 
select 'SUBMIT'          from dual  union all 
select 'APPROVE'         from dual  union all 
select 'APPROVE'         from dual  union all 
select 'APPROVAL_REJECT' from dual  union all 
select 'SUBMIT'          from dual  union all 
select 'APPROVE'         from dual  union all 
select 'APPROVE'         from dual  union all 
select 'APPROVE'         from dual            

) select a from  
(select  a,row_number() over (order by rownum) rn from t  ) c 
where c.rn>=
( select  max(rn) from (
select a,row_number() over (order by rownum) rn from t )  
where a='SUBMIT' )