oracle库表修改

创建新表

create table aa_than_notes(
  ID number(12) NOT NULL ,
  SOLUTION varchar2(255) default NULL,
  ERROCAUSE varchar2(255) default NULL,
  ERROORAGANINAME varchar2(255) default NULL,
  SYSORGANINAME varchar2(255) default NULL,
  USERORGANINAME varchar2(255) default NULL,
  PRIMARY KEY  (ID)
)

create sequence aa_than_notes_seq minvalue 1 maxvalue 99999999 start with 1 increment by 1 cache 20;

insert into aa_than_notes(id,SOLUTION, ERROCAUSE ,ERROORAGANINAME ,SYSORGANINAME ,USERORGANINAME ) values (aa_than_notes_seq.nextval,'nsw','123','1','2','3');

 

触发器

CREATE OR REPLACE TRIGGER "aa_than_notes_trig"

  BEFORE INSERT ON aa_than_notes

  REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW

DECLARE

BEGIN

  SELECT aa_than_notes_seq.NEXTVAL INTO :NEW.ID FROM DUAL;

END aa_than_notes_trig;

 

 

修改表字段长度，
alter table RDMP_TEMPORARY_PROPERTY modify(task_id char(100));
添加一列，
alter table RDMP_TEMPORARY_PROPERTY add(tag varchar2(40))

修改一列，

alter table RDMP_TEMPORARY_PROPERTY modify tag varchar2(20);

删除一列，

alter table RDMP_TEMPORARY_PROPERTY drop column tag;

增加多列：

   alter table emp4 add (test varchar2(10),test2 number);

修改多列：

   alter table emp4 modify (test varchar2(20),test2 varchar2(20));

删除多列：

   alter table emp4 drop (test,test2);

删除表中所有数据
delete from  RDMP_TEMPORARY_PROPERTY t where t.task_id is not null