admin 2019.12.02 08:38 Views : 234
select ROWNUM,NVL(TO_NUMBER(TOTAL_AMOUNT),0) from history
WHERE ROWNUM = 10
UPDATE history
SET ROW_NUM = ROWNUM;