冰逸101

摘要： --插入数据 insert into emp (empno,ename,job)values ('0000','哈哈','学生');--插入数据（插入一行） insert into emp (empno,ename,job)values ('0001','哈哈1','学生1'); insert into emp (empno,ename,job)values ('0002','哈哈2','学生2... 阅读全文

摘要： create sequence 订单_订单编号_seq -- 创建序列 (成功后在sequence中查询) increment by 1 start with 1 maxvalue 100 nocycle nocache;select * from user_sequences --查询序列 ALTER SEQUENCE ... 阅读全文

摘要： --currval/nextval的区别 select * from 订单 delete from 订单 where 订单编号=40 --nextval INSERT INTO 订单(订单编号,单价) --nextval每执行一次,会在下列插入一行,序号会依次增加 VALUES (订单_订单编号_seq.nextval, 4500); ... 阅读全文