批次更新问题

Question

批次更新问题，比如 有一个 表table有个字段name  现在如何写sql，把name依一定顺序 值变为 'name1','name2',...'name100'这样

Answer 1

SQL> select * from eric_tmp
  2  /NAMES                COURSE                   GRADE
-------------------- -------------------- ---------
a                    语文                          62
b                    语文                          70
c                    语文                          80SQL> update eric_tmp t set t.names = (select 'name'||rn from (select rownum rn, names from eric_tmp)
 tt where t.NAMES = tt.NAMES)
  2  /3 rows updated.SQL> select * from eric_tmp
  2  /NAMES                COURSE                   GRADE
-------------------- -------------------- ---------
name1                语文                          62
name2                语文                          70
name3                语文                          80SQL>