17,086
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE test
(
pnum NUMBER,
pname varchar2(10),
pkucun GENERATED ALWAYS AS ( pnum + 100 ) VIRTUAL
);
insert into test (pnum,pname) values(20,'pp');
commit;
select * from test;
drop table book;
--创建表
create table book(
bookId varchar2(4) primary key,
name varchar2(20)
);
--创建序列
create sequence book_seq start with 1 increment by 1;
--创建触发器
create or replace trigger book_trigger
before insert on book
for each row
begin
select book_seq.nextval into :new.bookId from dual;
end ;
--添加数据
insert into book(name) values ('cc');
insert into book(name) values ('dd');
commit;
不懂的话,请点击这里