oracle 创建序列

创建序列，没仔细研究过这段SQL意思，但可以套用注意四处名字对应
CREATE SEQUENCE seq_news_class
INCREMENT BY 1
START WITH 1
nomaxvalue
nominvalue
nocache;
CREATE OR REPLACE TRIGGER "tig_news_class"
BEFORE INSERT ON LF_NEWS_CLASS
FOR each ROW WHEN(NEW.id IS NULL)
BEGIN
SELECT seq_news_class.NEXTVAL INTO :NEW.id FROM dual;
END;

------------------------------------------------------------------------------------------

name is already used by an existing object或

cannot insert NULL into (."ID")

的问题

先搜索出来再

SELECT *from all_objects where object_name like '%NEWS_CLASS%';

再删除

declare 

      num   number; 

begin 

select  count（1） into  num  from  user_sequences  where  sequence_name= 'SEQ_NEWS_CLASS'; 

      if   num=1   then 

          execute immediate 'drop SEQUENCE SEQ_NEWS_CLASS'; 

      end   if;

end;