1.Oracle实现主键自增:
①新建序列:create sequence user_test start with 1 increment by 1;
②用法:insert into tb_user(id,name) values(user_test.nextval,'xiaowang');
2.Oracle实现主键自增策略:
Oracle若实现主键(id)自增,取返回值,返回值为本次操作影响的行数,并非id,要想获得ID值,使用user.getId()即可获取到刚才插入的id.
3.Oracle与MySQL一次插入多条数据的区别。
a.Oracle:
insert all
into tb_test(id,name) values(1,'a')
into tb_test(id,name) values(2,'b')
into tb_test(id,name) values(3,'c')
select * from dual;
b.MySQL:
insert into tb_test(id,name) values(1,'a'),(2,'b'),(3,'c');
**Oracle插入时可以是不同表