UPDATE table1 t1
SET rec_sl =
(SELECT rn
FROM (SELECT ROWID,
ROW_NUMBER () OVER (ORDER BY ss_created_on) AS rn
FROM table1) t2
WHERE t2.ROWID = t1.ROWID);
SET rec_sl =
(SELECT rn
FROM (SELECT ROWID,
ROW_NUMBER () OVER (ORDER BY ss_created_on) AS rn
FROM table1) t2
WHERE t2.ROWID = t1.ROWID);

কোন মন্তব্য নেই:
একটি মন্তব্য পোস্ট করুন