Oracle implementation MySQL Updates update limit

Oracle gives the feeling is very backward, the use is very inconvenient, Toad this software is stupid and dull, PL/SQL is, the 90 's interface style, speed still stuck to death. and Oracle does not support limit. by default7#zbphp.com

Update tb_news set typeid =9 where ID in (select-ID from (select-        rownum RN, a.* from (select            * FROM Tb_news where typeid not in (3,6,5,9)        ) a) where RN between 0 and)       ); commit;//at the end of this commit will error! No language

Oracle implementation MySQL Updates update limit