I'm getting when i try to create a database from a SQL code i got from my friend. I want to add it to APEX to create some school project so i need all help I can get.
Below is the whole code and I'm getting problem with this part, actually every part with: "Create or replace....."
CREATE OR REPLACE TRIGGER "BI_MJESTO_12"
before insert on "MJESTO_12"
for each row
begin
if :NEW."PTT" is null then
select "MJESTO_12_SEQ".nextval into :NEW."PTT" from sys.dual;
end if;
end;
CREATE TABLE "MJESTO_12"
( "PTT" VARCHAR2(20),
"NAZIV" VARCHAR2(30),
CONSTRAINT "MJESTO_12_PK" PRIMARY KEY ("PTT")
USING INDEX ENABLE,
CONSTRAINT "MJESTO_12_UK1" UNIQUE ("NAZIV")
USING INDEX ENABLE
)
/
CREATE OR REPLACE TRIGGER "BI_MJESTO_12"
before insert on "MJESTO_12"
for each row
begin
if :NEW."PTT" is null then
select "MJESTO_12_SEQ".nextval into :NEW."PTT" from sys.dual;
end if;
end;
/
ALTER TRIGGER "BI_MJESTO_12" ENABLE
/
CREATE TABLE "IGRAONICA_12"
( "REG_BROJ" NUMBER NOT NULL ENABLE,
"NAZIV" VARCHAR2(20),
"ADRESA" VARCHAR2(30),
"VLASNIK" VARCHAR2(25),
"TELEFON" VARCHAR2(20),
"MJESTO" VARCHAR2(20),
CONSTRAINT "IGRAONICA_12_PK" PRIMARY KEY ("REG_BROJ")
USING INDEX ENABLE,
CONSTRAINT "IGRAONICA_12_UK1" UNIQUE ("NAZIV")
USING INDEX ENABLE
)
/
ALTER TABLE "IGRAONICA_12" ADD CONSTRAINT "IGRAONICA_12_FK" FOREIGN KEY ("MJESTO")
REFERENCES "MJESTO_12" ("PTT") ENABLE
/
CREATE OR REPLACE TRIGGER "BI_IGRAONICA_12"
before insert on "IGRAONICA_12"
for each row
begin
if :NEW."REG_BROJ" is null then
select "IGRAONICA_12_SEQ".nextval into :NEW."REG_BROJ" from sys.dual;
end if;
end;
/
ALTER TRIGGER "BI_IGRAONICA_12" ENABLE
/
CREATE TABLE "RADNIK_12"
( "JMBG" VARCHAR2(20) NOT NULL ENABLE,
"IME" VARCHAR2(10) NOT NULL ENABLE,
"PREZIME" VARCHAR2(10) NOT NULL ENABLE,
"DAT_ZAPOSLENJA" VARCHAR2(20),
"PLATA" VARCHAR2(10),
"GDJE_RADI" NUMBER,
"GDJE_ZIVI" VARCHAR2(20),
CONSTRAINT "RADNIK_12_PK" PRIMARY KEY ("JMBG")
USING INDEX ENABLE
)
/
ALTER TABLE "RADNIK_12" ADD CONSTRAINT "RADNIK_12_FK" FOREIGN KEY ("GDJE_RADI")
REFERENCES "IGRAONICA_12" ("REG_BROJ") ENABLE
/
ALTER TABLE "RADNIK_12" ADD CONSTRAINT "RADNIK_12_MJESTO_FK" FOREIGN KEY ("GDJE_ZIVI")
REFERENCES "MJESTO_12" ("PTT") ENABLE
/
CREATE OR REPLACE TRIGGER "BI_RADNIK_12"
before insert on "RADNIK_12"
for each row
begin
if :NEW."JMBG" is null then
select "RADNIK_12_SEQ".nextval into :NEW."JMBG" from sys.dual;
end if;
end;
/
ALTER TRIGGER "BI_RADNIK_12" ENABLE
/
CREATE TABLE "RACUNAR_12"
( "BROJ" VARCHAR2(10),
"MREZ_IME" VARCHAR2(15),
"KOJOJ_IGRAONICI_PRIPADA" NUMBER,
CONSTRAINT "RACUNAR_12_PK" PRIMARY KEY ("BROJ")
USING INDEX ENABLE,
CONSTRAINT "RACUNAR_12_UK1" UNIQUE ("MREZ_IME")
USING INDEX ENABLE
)
/
ALTER TABLE "RACUNAR_12" ADD CONSTRAINT "RACUNAR_12_FK" FOREIGN KEY ("KOJOJ_IGRAONICI_PRIPADA")
REFERENCES "IGRAONICA_12" ("REG_BROJ") ENABLE
/
CREATE OR REPLACE TRIGGER "BI_RACUNAR_12"
before insert on "RACUNAR_12"
for each row
begin
if :NEW."BROJ" is null then
select "RACUNAR_12_SEQ".nextval into :NEW."BROJ" from sys.dual;
end if;
end;
/
ALTER TRIGGER "BI_RACUNAR_12" ENABLE
/
CREATE TABLE "KOMPONENTA_12"
( "ID" VARCHAR2(10),
"IME" VARCHAR2(20),
"PROIZVODJAC" VARCHAR2(20),
"GDJE_JE_UGRADJENA" VARCHAR2(10),
CONSTRAINT "KOMPONENTA_12_PK" PRIMARY KEY ("ID")
USING INDEX ENABLE
)
/
ALTER TABLE "KOMPONENTA_12" ADD CONSTRAINT "KOMPONENTA_12_FK" FOREIGN KEY ("GDJE_JE_UGRADJENA")
REFERENCES "RACUNAR_12" ("BROJ") ENABLE
/
CREATE OR REPLACE TRIGGER "BI_KOMPONENTA_12"
before insert on "KOMPONENTA_12"
for each row
begin
if :NEW."ID" is null then
select "KOMPONENTA_12_SEQ".nextval into :NEW."ID" from sys.dual;
end if;
end;
/
ALTER TRIGGER "BI_KOMPONENTA_12" ENABLE
/
CREATE TABLE "GRAFICKA_12"
( "ID" VARCHAR2(10),
"IME" VARCHAR2(20),
"PROIZVODJAC" VARCHAR2(20),
"GDJE_JE_UGRADJENA" VARCHAR2(10),
"KOLICINA_MEMORIJE" VARCHAR2(10),
CONSTRAINT "GRAFICKA_12_PK" PRIMARY KEY ("ID")
USING INDEX ENABLE
)
/
ALTER TABLE "GRAFICKA_12" ADD CONSTRAINT "GRAFICKA_12_FK" FOREIGN KEY ("GDJE_JE_UGRADJENA")
REFERENCES "RACUNAR_12" ("BROJ") ENABLE
/
CREATE OR REPLACE TRIGGER "BI_GRAFICKA_12"
before insert on "GRAFICKA_12"
for each row
begin
if :NEW."ID" is null then
select "GRAFICKA_12_SEQ".nextval into :NEW."ID" from sys.dual;
end if;
end;
/
ALTER TRIGGER "BI_GRAFICKA_12" ENABLE
/
CREATE TABLE "MONITOR_12"
( "ID" VARCHAR2(10),
"IME" VARCHAR2(20),
"PROIZVODJAC" VARCHAR2(20),
"GDJE_JE_UGRADJENA" VARCHAR2(20),
"DIMENZIJE" VARCHAR2(10),
CONSTRAINT "MONITOR_12_PK" PRIMARY KEY ("ID")
USING INDEX ENABLE
)
/
ALTER TABLE "MONITOR_12" ADD CONSTRAINT "MONITOR_12_FK" FOREIGN KEY ("GDJE_JE_UGRADJENA")
REFERENCES "RACUNAR_12" ("BROJ") ENABLE
/
CREATE OR REPLACE TRIGGER "BI_MONITOR_12"
before insert on "MONITOR_12"
for each row
begin
if :NEW."ID" is null then
select "MONITOR_12_SEQ".nextval into :NEW."ID" from sys.dual;
end if;
end;
/
ALTER TRIGGER "BI_MONITOR_12" ENABLE
/
CREATE TABLE "RAM_12"
( "ID" VARCHAR2(10),
"IME" VARCHAR2(20),
"PROIZVODJAC" VARCHAR2(20),
"GDJE_JE_UGRADJENA" VARCHAR2(20),
"TIP" VARCHAR2(10),
"KAPACITET" NUMBER,
CONSTRAINT "RAM_12_PK" PRIMARY KEY ("ID")
USING INDEX ENABLE
)
/
ALTER TABLE "RAM_12" ADD CONSTRAINT "RAM_12_FK" FOREIGN KEY ("GDJE_JE_UGRADJENA")
REFERENCES "RACUNAR_12" ("BROJ") ENABLE
/
CREATE OR REPLACE TRIGGER "BI_RAM_12"
before insert on "RAM_12"
for each row
begin
if :NEW."ID" is null then
select "RAM_12_SEQ".nextval into :NEW."ID" from sys.dual;
end if;
end;
/
ALTER TRIGGER "BI_RAM_12" ENABLE
/
CREATE TABLE "HARD_DISC_12"
( "ID" VARCHAR2(10),
"IME" VARCHAR2(20),
"PROIZVODJAC" VARCHAR2(20),
"GDJE_JE_UGRADJENA" VARCHAR2(10),
"BRZINA_OBRTAJA" VARCHAR2(10),
"KAPACITET" NUMBER,
CONSTRAINT "HARD_DISC_12_PK" PRIMARY KEY ("ID")
USING INDEX ENABLE
)
/
ALTER TABLE "HARD_DISC_12" ADD CONSTRAINT "HARD_DISC_12_FK" FOREIGN KEY ("GDJE_JE_UGRADJENA")
REFERENCES "RACUNAR_12" ("BROJ") ENABLE
/
CREATE OR REPLACE TRIGGER "BI_HARD_DISC_12"
before insert on "HARD_DISC_12"
for each row
begin
if :NEW."ID" is null then
select "HARD_DISC_12_SEQ".nextval into :NEW."ID" from sys.dual;
end if;
end;
/
ALTER TRIGGER "BI_HARD_DISC_12" ENABLE
/
CREATE TABLE "CD_ROM_12"
( "ID" VARCHAR2(10),
"IME" VARCHAR2(30),
"PROIZVODJAC" VARCHAR2(20),
"GDJE_JE_UGRADJENA" VARCHAR2(10),
"BRZINA" VARCHAR2(20),
CONSTRAINT "CD_ROM_12_PK" PRIMARY KEY ("ID")
USING INDEX ENABLE
)
/
ALTER TABLE "CD_ROM_12" ADD CONSTRAINT "CD_ROM_12_FK" FOREIGN KEY ("GDJE_JE_UGRADJENA")
REFERENCES "RACUNAR_12" ("BROJ") ENABLE
/
CREATE OR REPLACE TRIGGER "BI_CD_ROM_12"
before insert on "CD_ROM_12"
for each row
begin
if :NEW."ID" is null then
select "CD_ROM_12_SEQ".nextval into :NEW."ID" from sys.dual;
end if;
end;
/
ALTER TRIGGER "BI_CD_ROM_12" ENABLE
/
CREATE TABLE "MATICNA_PLOCA"
( "ID" VARCHAR2(10),
"IME" VARCHAR2(40),
"PROIZVODJAC" VARCHAR2(20),
"GDJE_JE_UGRADJENA" VARCHAR2(10),
"CIPSET" VARCHAR2(20),
CONSTRAINT "MATICNA_PLOCA_PK" PRIMARY KEY ("ID")
USING INDEX ENABLE
)
/
ALTER TABLE "MATICNA_PLOCA" ADD CONSTRAINT "MATICNA_PLOCA_FK" FOREIGN KEY ("GDJE_JE_UGRADJENA")
REFERENCES "RACUNAR_12" ("BROJ") ENABLE
/
CREATE OR REPLACE TRIGGER "BI_MATICNA_PLOCA"
before insert on "MATICNA_PLOCA"
for each row
begin
if :NEW."ID" is null then
select "MAT_PLOCA_12_SEQ".nextval into :NEW."ID" from sys.dual;
end if;
end;
/
ALTER TRIGGER "BI_MATICNA_PLOCA" ENABLE
/
CREATE TABLE "PROCESOR_12"
( "ID" VARCHAR2(10),
"IME" VARCHAR2(20),
"PROIZVODJAC" VARCHAR2(20),
"GDJE_JE_UGRADJENA" VARCHAR2(20),
"FREKVENCIJA" NUMBER,
CONSTRAINT "PROCESOR_12_PK" PRIMARY KEY ("ID")
USING INDEX ENABLE
)
/
ALTER TABLE "PROCESOR_12" ADD CONSTRAINT "PROCESOR_12_FK" FOREIGN KEY ("GDJE_JE_UGRADJENA")
REFERENCES "RACUNAR_12" ("BROJ") ENABLE
/
CREATE OR REPLACE TRIGGER "BI_PROCESOR_12"
before insert on "PROCESOR_12"
for each row
begin
if :NEW."ID" is null then
select "PROCESOR_12_SEQ".nextval into :NEW."ID" from sys.dual;
end if;
end;
/
ALTER TRIGGER "BI_PROCESOR_12" ENABLE
/