rownum写法,update tsfana set settle_dt 20070508 where fwd_ins_id_cd 03033930 and rownum
rownum写法,update tsfana set settle_dt = '20070508 ' where fwd_ins_id_cd = '03033930 ' and rownum > 70
------解决方法--------------------------------------------------------
rownum不能用大于号
这是是select * from xxtable where rownum < x(或者 <=一个数值)
------解决方法--------------------------------------------------------
rownum相当于SQL里的top..不能用于大于..