就是会自动给该列复出始值,之后也能对该字段做修改create table b ( id number, name varchar(20) default 'zhang');SQL> begin 2 for i in 1..5 loop 3 insert into b(id) 4 values (i); 5 end loop; 6 end; 7 /PL/SQL procedure successfully completed.SQL> select * from b; ID NAME ---------- -------------------- 1 zhang 2 zhang 3 zhang 4 zhang 5 zhangSQL> update b 2 set name='zz';5 rows updated.SQL> select * from b; ID NAME ---------- -------------------- 1 zz 2 zz 3 zz 4 zz 5 zz
id number,
name varchar(20) default 'zhang');SQL> begin
2 for i in 1..5 loop
3 insert into b(id)
4 values (i);
5 end loop;
6 end;
7 /PL/SQL procedure successfully completed.SQL> select * from b; ID NAME
---------- --------------------
1 zhang
2 zhang
3 zhang
4 zhang
5 zhangSQL> update b
2 set name='zz';5 rows updated.SQL> select * from b; ID NAME
---------- --------------------
1 zz
2 zz
3 zz
4 zz
5 zz