repositorio.sql

CREATE TABLE  "PESSOAS" 
   (	"ID" NUMBER, 
	"NOME" VARCHAR2(50), 
	 CONSTRAINT "PESSOAS_PK" PRIMARY KEY ("ID") ENABLE
   )
/
CREATE TABLE  "TELEFONES" 
   (	"ID" NUMBER NOT NULL ENABLE, 
	"PESSOA_ID" NUMBER NOT NULL ENABLE, 
	"NUMERO" VARCHAR2(10) NOT NULL ENABLE, 
	 CONSTRAINT "TELEFONES_PK" PRIMARY KEY ("ID") ENABLE, 
	 CONSTRAINT "TELEFONES_FK" FOREIGN KEY ("PESSOA_ID")
	  REFERENCES  "PESSOAS" ("ID") ENABLE
   )
/

Rem Nenhum function encontrado para gerar a DDL.
CREATE UNIQUE INDEX  "PESSOAS_PK" ON  "PESSOAS" ("ID")
/
CREATE UNIQUE INDEX  "TELEFONES_PK" ON  "TELEFONES" ("ID")
/

Rem Nenhum procedure encontrado para gerar a DDL.
 CREATE SEQUENCE   "PESSOAS_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER  NOCYCLE
/
 CREATE SEQUENCE   "TELEFONES_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER  NOCYCLE
/

CREATE OR REPLACE TRIGGER  "BI_PESSOAS" 
  before insert on "PESSOAS"               
  for each row  
begin   
    select "PESSOAS_SEQ".nextval into :NEW.ID from dual; 
end; 

/
ALTER TRIGGER  "BI_PESSOAS" ENABLE
/
CREATE OR REPLACE TRIGGER  "BI_TELEFONES" 
  before insert on "TELEFONES"               
  for each row  
begin   
    select "TELEFONES_SEQ".nextval into :NEW.ID from dual; 
end; 

/
ALTER TRIGGER  "BI_TELEFONES" ENABLE
/