Oracle 建表语句
create table table_name(
id numner(12),
text verchar2(255 CHAR) not null,
PID varchar2(32 BYTE) NOT NULL,
status number(1) DEFAULT 0 null
)
ALTER TABLE "test"."table_name" ADD PRIMARY KEY ("ID");
comment on column table_name.id is '主键';
comment on column table_name.text is '说明';
comment on column table_name.status is '状态';
CREATE SEQUENCE cw_bl_id_increment
INCREMENT BY 1
START WITH 1
MAXVALUE 1.0E20
MINVALUE 1
NOCYCLE
CACHE 20
NOORDER
create or replace trigger 触发器名
before insert on 表名
for each row
begin
select 序列名.nextval into :new.id from dual;
end;
ALTER TABLE table_name ADD (
RS_SFTG NUMBER (1),
RS_TGJE VARCHAR2 (255 CHAR)
);
alter table table_name drop column RS_SFTG ;
序列参数说明:
CREATE SEQUENCE SEQNAME
INCREMENT BY 1
START WITH 1
MAXVALUE 1.0E20
MINVALUE 1
CYCLE or NOCYCLE
CACHE 20
ORDER or NOORDER