先建表.. 建表序列實現.. 比如:create table tbname(id number(3) not null, name varchar2(40), sex varchar2(1), create sequence s_country_id increment by 1 start with 1 maxvalue 999; insert into tbname(s_country_id.nextval,'na','1'); id :行标志,范围在1-999之间,非空 名字和性別默認..
create table ttt (id NUMBER(8), dt DATE default sysdate, flag CHAR(1) default 'N');oracle没有自动增长列,用序列实现
建表序列實現.. 比如:create table tbname(id number(3) not null,
name varchar2(40),
sex varchar2(1),
create sequence s_country_id increment by 1 start with 1 maxvalue 999;
insert into tbname(s_country_id.nextval,'na','1'); id :行标志,范围在1-999之间,非空 名字和性別默認..
(id NUMBER(8),
dt DATE default sysdate,
flag CHAR(1) default 'N');oracle没有自动增长列,用序列实现