Oracle中自增队列、触发器、存储过程

//自增队列出发器
create sequence VerticalSecData_seq start with 1 increment by 1;   
create or replace trigger VerticalSecData_trigger       
before insert on VerticalSecData       
for each row       
begin       
select VerticalSecData_seq.nextval into :new.ID from dual;      
end ;  

// 关联删除触发器
create or replace trigger RoadParkSpace_Delete
  before delete on Road  
  for each row
begin
  DELETE   ParkSpace WHERE RoadId =:old.id;
end RoadParkSpace_Delete;

//存储过程

使用自定义变量TestID

DECLARE
TestID INTEGER;
BEGIN
  TestID := 5;
execute immediate
   'insert into test(ID, Text) values(:TestID, ''5'')' using TestID;
end;