CREATE TABLE  "PRIMER1" 
   (	"ID" NUMBER NOT NULL ENABLE, 
	"NAME" VARCHAR2(255), 
	"DATE_P" DATE, 
	 CONSTRAINT "PRIMER1_PK" PRIMARY KEY ("ID") ENABLE
   ) ;

CREATE OR REPLACE TRIGGER  "BI_PRIMER1" 
  before insert on "PRIMER1"               
  for each row  
begin   
  if :NEW."ID" is null then 
    select "PRIMER1_SEQ".nextval into :NEW."ID" from dual; 
  end if; 
end; 

/
ALTER TRIGGER  "BI_PRIMER1" ENABLE;


CREATE TABLE  "PRIMER2" 
   (	"ID" NUMBER NOT NULL ENABLE, 
	"ID_PRIM1" NUMBER, 
	"INFO" VARCHAR2(255), 
	 CONSTRAINT "PRIMER2_PK" PRIMARY KEY ("ID") ENABLE
   ) ;ALTER TABLE  "PRIMER2" ADD CONSTRAINT "PRIMER2_CON" FOREIGN KEY ("ID_PRIM1")
	  REFERENCES  "PRIMER1" ("ID") ON DELETE CASCADE ENABLE;

CREATE OR REPLACE TRIGGER  "BI_PRIMER2" 
  before insert on "PRIMER2"               
  for each row  
begin   
  if :NEW."ID" is null then 
    select "PRIMER2_SEQ".nextval into :NEW."ID" from dual; 
  end if; 
end; 

/
ALTER TRIGGER  "BI_PRIMER2" ENABLE;