创建序列,没仔细研究过这段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;