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