Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.

Delphi 7 i Oracle

[es] :: Pascal / Delphi / Kylix :: Delphi 7 i Oracle

[ Pregleda: 2005 | Odgovora: 16 ] > FB > Twit

Postavi temu Odgovori

Autor

Pretraga teme: Traži
Markiranje Štampanje RSS

popmilan76
Programer

Član broj: 295089
Poruke: 1153
*.dynamic.isp.telekom.rs.



+4 Profil

icon Delphi 7 i Oracle19.02.2016. u 22:17 - pre 53 meseci
Kako se Delphi 7 povezuje sa Oracle bazom i da li su potrebni neke dodatne komponente za povezivanje?Hvala.
 
Odgovor na temu

captPicard
programer
more i planine

Član broj: 216084
Poruke: 1119



+19 Profil

icon Re: Delphi 7 i Oracle20.02.2016. u 23:43 - pre 53 meseci
Prvi link na googleu
F
 
Odgovor na temu

popmilan76
Programer

Član broj: 295089
Poruke: 1153
*.dynamic.isp.telekom.rs.



+4 Profil

icon Re: Delphi 7 i Oracle24.02.2016. u 14:46 - pre 53 meseci
Da li je moguce otvoriti bazu koja ima sufiks .sql,nisam siguran da je u Oracle?
 
Odgovor na temu

djoka_l
Beograd

Član broj: 56075
Poruke: 2861



+1162 Profil

icon Re: Delphi 7 i Oracle24.02.2016. u 14:52 - pre 53 meseci
Oracle baza se sastoji od više fajlova i ti fajlovi se ne čitaju direktno nego pozivom oracla (slenjem upita oracle bazi). U stvari fajlovi se ne čitaju nego se zahvataju podaci iz tabela - ne postoji 1:1 veza između tabele i fajla, jedan fajl je deo nečega što se zove tablespace, a tablespace može sadržati podatke iz više tabela i indeksa.

Fajlovi sa ekstenzijom .sql su obično skriptovi a ne fajlovi sa podacima.
 
Odgovor na temu

popmilan76
Programer

Član broj: 295089
Poruke: 1153
*.dynamic.isp.telekom.rs.



+4 Profil

icon Re: Delphi 7 i Oracle24.02.2016. u 16:22 - pre 53 meseci
Da,i jeste scripta sql,to sam video kasnije...jel se moze pprocitati ta skripta i menjati se ...
 
Odgovor na temu

savkic
Igor Savkić

Moderator
Član broj: 92186
Poruke: 2628



+69 Profil

icon Re: Delphi 7 i Oracle24.02.2016. u 16:25 - pre 53 meseci
Sql skripte su uglavnom klasični txt fajlovi tako da ih možeš otvoriti u bilo kom tekst editoru.
 
Odgovor na temu

popmilan76
Programer

Član broj: 295089
Poruke: 1153
*.dynamic.isp.telekom.rs.



+4 Profil

icon Re: Delphi 7 i Oracle24.02.2016. u 17:13 - pre 53 meseci
Ono sto meni treba jeste da napravim aplikaciju,koja bi ucitala to iz sql.file...Kda otvorim to pomocu notepad vidim sql jezik,za pravljenje tabela,polja i slicno...U stvari,evo prekopiracu,sta mi je u njemu...


--------------------------------------------------------
-- File created - ??????-???????-23-2016
--------------------------------------------------------
DROP TABLE "STEFAN"."ADRESA" cascade constraints;
DROP TABLE "STEFAN"."CARINARNICA" cascade constraints;
DROP TABLE "STEFAN"."CENAROBE" cascade constraints;
DROP TABLE "STEFAN"."DELATNOST" cascade constraints;
DROP TABLE "STEFAN"."FAKTURA" cascade constraints;
DROP TABLE "STEFAN"."IZJAVADOVOZENJAVOZILA" cascade constraints;
DROP TABLE "STEFAN"."JEDINICAMERE" cascade constraints;
DROP TABLE "STEFAN"."JEDINSTVENACARINSKAISPRAVA" cascade constraints;
DROP TABLE "STEFAN"."MESTO" cascade constraints;
DROP TABLE "STEFAN"."NARUDZBENICA" cascade constraints;
DROP TABLE "STEFAN"."OBRACUNCARINSKOGDUGA" cascade constraints;
DROP TABLE "STEFAN"."POSLOVNIPARTNER" cascade constraints;
DROP TABLE "STEFAN"."RADNIK" cascade constraints;
DROP TABLE "STEFAN"."ROBA" cascade constraints;
DROP TABLE "STEFAN"."STAVKAJCI" cascade constraints;
DROP TABLE "STEFAN"."STAVKANARUDZBENICE" cascade constraints;
DROP TABLE "STEFAN"."STAVKAOCD" cascade constraints;
DROP TABLE "STEFAN"."STAVKEFAKTURE" cascade constraints;
DROP TABLE "STEFAN"."TRANSPORTNOSREDSTVO" cascade constraints;
DROP TABLE "STEFAN"."ULICA" cascade constraints;
DROP TABLE "STEFAN"."VALUTA" cascade constraints;
DROP TABLE "STEFAN"."VRSTETRANSPORTNOGSREDSTVA" cascade constraints;
DROP TABLE "STEFAN"."ZEMLJA" cascade constraints;
--------------------------------------------------------
-- DDL for Table ADRESA
--------------------------------------------------------

CREATE TABLE "STEFAN"."ADRESA"
( "SIFRAMESTA" NUMBER,
"SIFRAULICE" NUMBER,
"BROJ" NUMBER,
"SPRAT" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table CARINARNICA
--------------------------------------------------------

CREATE TABLE "STEFAN"."CARINARNICA"
( "SIFRACARINARNICE" NUMBER,
"NAZIVCARINARNIICE" VARCHAR2(144 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table CENAROBE
--------------------------------------------------------

CREATE TABLE "STEFAN"."CENAROBE"
( "SIFRAROBE" NUMBER,
"DATUMOD" DATE,
"VREDNOST" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table DELATNOST
--------------------------------------------------------

CREATE TABLE "STEFAN"."DELATNOST"
( "SIFRADELATNOSTI" NUMBER,
"NAZIVDELATNOSTI" VARCHAR2(144 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table FAKTURA
--------------------------------------------------------

CREATE TABLE "STEFAN"."FAKTURA"
( "BROJFAKTURE" NUMBER,
"DATUMFAKTURE" DATE,
"ROKUPLATE" DATE,
"SIFRARADNIKA" NUMBER,
"SIFRAPP" NUMBER,
"SIFRAVALUTE" NUMBER,
"BROJNARUDZBENICE" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table IZJAVADOVOZENJAVOZILA
--------------------------------------------------------

CREATE TABLE "STEFAN"."IZJAVADOVOZENJAVOZILA"
( "SIFRAIZJAVE" NUMBER,
"OPIS" VARCHAR2(1024 BYTE),
"SIFRARADNIKA" NUMBER,
"SIFRATS" NUMBER,
"SIFRAPP" NUMBER,
"BROJFAKTURE" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table JEDINICAMERE
--------------------------------------------------------

CREATE TABLE "STEFAN"."JEDINICAMERE"
( "SIFRAJM" NUMBER,
"NAZIVJM" VARCHAR2(144 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table JEDINSTVENACARINSKAISPRAVA
--------------------------------------------------------

CREATE TABLE "STEFAN"."JEDINSTVENACARINSKAISPRAVA"
( "REFERENTNIBROJ" NUMBER,
"DATUMJCI" DATE,
"OPIS" VARCHAR2(1024 BYTE),
"BROJFAKTURE" NUMBER,
"SIFRARADNIKA" NUMBER,
"SIFRAPP" NUMBER,
"SIFRAVALUTE" NUMBER,
"SIFRACARINARNICE" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table MESTO
--------------------------------------------------------

CREATE TABLE "STEFAN"."MESTO"
( "SIFRAMESTA" NUMBER,
"NAZIVMESTA" VARCHAR2(144 BYTE),
"PTTBROJ" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table NARUDZBENICA
--------------------------------------------------------

CREATE TABLE "STEFAN"."NARUDZBENICA"
( "BROJNARUDZBENICE" NUMBER,
"DATUMNARUDZBENICE" DATE,
"DATUMDO" DATE,
"NAPOMENA" VARCHAR2(1024 BYTE),
"SIFRARADNIKA" NUMBER,
"SIFRAPP" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table OBRACUNCARINSKOGDUGA
--------------------------------------------------------

CREATE TABLE "STEFAN"."OBRACUNCARINSKOGDUGA"
( "BROJOBRACUNA" NUMBER,
"DATUMOBRACUNA" DATE,
"NAPOMENA" VARCHAR2(1024 BYTE),
"REFERENTNIBROJ" NUMBER,
"SIFRARADNIKA" NUMBER,
"SIFRAPP" NUMBER,
"SIFRACARINARNICE" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table POSLOVNIPARTNER
--------------------------------------------------------

CREATE TABLE "STEFAN"."POSLOVNIPARTNER"
( "SIFRAPP" NUMBER,
"NAZIVPP" VARCHAR2(144 BYTE),
"TELEFON" NUMBER,
"FAX" NUMBER,
"EMAIL" VARCHAR2(144 BYTE),
"SIFRAZEMLJE" NUMBER,
"SIFRADELATNOSTI" NUMBER,
"SIFRAMESTA" NUMBER,
"SIFRAULICE" NUMBER,
"BROJ" NUMBER,
"SPRAT" NUMBER,
"NAZIVDELATNOSTI" VARCHAR2(144 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table RADNIK
--------------------------------------------------------

CREATE TABLE "STEFAN"."RADNIK"
( "SIFRARADNIKA" NUMBER,
"IMEPREZIME" VARCHAR2(144 BYTE),
"TELEFON" NUMBER,
"JMBG" NUMBER(13,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table ROBA
--------------------------------------------------------

CREATE TABLE "STEFAN"."ROBA"
( "SIFRAROBE" NUMBER,
"NAZIVROBE" VARCHAR2(144 BYTE),
"SIFRAJM" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table STAVKAJCI
--------------------------------------------------------

CREATE TABLE "STEFAN"."STAVKAJCI"
( "REFERENTNIBROJ" NUMBER,
"RBSTAVKEJCI" NUMBER,
"KOLICINA" NUMBER,
"BROJFAKTURE" NUMBER,
"RBSTAVKEFAKTURE" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table STAVKANARUDZBENICE
--------------------------------------------------------

CREATE TABLE "STEFAN"."STAVKANARUDZBENICE"
( "BROJNARUDZBENICE" NUMBER,
"RB" NUMBER,
"KOLICINA" NUMBER,
"SIFRAROBE" NUMBER,
"DATUMNARUDZBENICE" DATE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table STAVKAOCD
--------------------------------------------------------

CREATE TABLE "STEFAN"."STAVKAOCD"
( "BROJOBRACUNA" NUMBER,
"RBSTAVKEOCD" NUMBER,
"KOLICINA" NUMBER,
"REFERENTNIBROJ" NUMBER,
"RBSTAVKEJCI" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table STAVKEFAKTURE
--------------------------------------------------------

CREATE TABLE "STEFAN"."STAVKEFAKTURE"
( "BROJFAKTURE" NUMBER,
"RBSTAVKEFAKTURE" NUMBER,
"KOLICINA" NUMBER,
"BROJNARUDZBENICE" NUMBER,
"RB" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table TRANSPORTNOSREDSTVO
--------------------------------------------------------

CREATE TABLE "STEFAN"."TRANSPORTNOSREDSTVO"
( "SIFRATS" NUMBER,
"NAZIVTS" VARCHAR2(144 BYTE),
"SIFRAVTS" NUMBER
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table ULICA
--------------------------------------------------------

CREATE TABLE "STEFAN"."ULICA"
( "SIFRAULICE" NUMBER,
"NAZIVULICE" VARCHAR2(144 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table VALUTA
--------------------------------------------------------

CREATE TABLE "STEFAN"."VALUTA"
( "SIFRAVALUTE" NUMBER,
"NAZIVVALUTE" VARCHAR2(144 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table VRSTETRANSPORTNOGSREDSTVA
--------------------------------------------------------

CREATE TABLE "STEFAN"."VRSTETRANSPORTNOGSREDSTVA"
( "SIFRAVTS" NUMBER,
"NAZIVVTS" VARCHAR2(144 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Table ZEMLJA
--------------------------------------------------------

CREATE TABLE "STEFAN"."ZEMLJA"
( "SIFRAZEMLJE" NUMBER,
"NAZIVZEMLJE" VARCHAR2(144 BYTE)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
REM INSERTING into STEFAN.ADRESA
SET DEFINE OFF;
Insert into STEFAN.ADRESA (SIFRAMESTA,SIFRAULICE,BROJ,SPRAT) values ('1','1','10','2');
Insert into STEFAN.ADRESA (SIFRAMESTA,SIFRAULICE,BROJ,SPRAT) values ('2','2','15','3');
Insert into STEFAN.ADRESA (SIFRAMESTA,SIFRAULICE,BROJ,SPRAT) values ('3','4','20','4');
REM INSERTING into STEFAN.CARINARNICA
SET DEFINE OFF;
Insert into STEFAN.CARINARNICA (SIFRACARINARNICE,NAZIVCARINARNIICE) values ('1','CARINALUKABEOGRAD');
Insert into STEFAN.CARINARNICA (SIFRACARINARNICE,NAZIVCARINARNIICE) values ('2','CARINATERMINAL');
REM INSERTING into STEFAN.CENAROBE
SET DEFINE OFF;
Insert into STEFAN.CENAROBE (SIFRAROBE,DATUMOD,VREDNOST) values ('1',to_date('23.02.2016','DD.MM.RRRR'),'31900');
Insert into STEFAN.CENAROBE (SIFRAROBE,DATUMOD,VREDNOST) values ('2',to_date('23.02.2016','DD.MM.RRRR'),'65000');
REM INSERTING into STEFAN.DELATNOST
SET DEFINE OFF;
Insert into STEFAN.DELATNOST (SIFRADELATNOSTI,NAZIVDELATNOSTI) values ('1','TEGOVINANAVELIKO');
Insert into STEFAN.DELATNOST (SIFRADELATNOSTI,NAZIVDELATNOSTI) values ('2','KOMERCIJALA');
Insert into STEFAN.DELATNOST (SIFRADELATNOSTI,NAZIVDELATNOSTI) values ('3','SPEDICIJA');
REM INSERTING into STEFAN.FAKTURA
SET DEFINE OFF;
Insert into STEFAN.FAKTURA (BROJFAKTURE,DATUMFAKTURE,ROKUPLATE,SIFRARADNIKA,SIFRAPP,SIFRAVALUTE,BROJNARUDZBENICE) values ('1',to_date('31.03.2015','DD.MM.RRRR'),to_date('30.05.2015','DD.MM.RRRR'),'1','1','2','1');
REM INSERTING into STEFAN.IZJAVADOVOZENJAVOZILA
SET DEFINE OFF;
Insert into STEFAN.IZJAVADOVOZENJAVOZILA (SIFRAIZJAVE,OPIS,SIFRARADNIKA,SIFRATS,SIFRAPP,BROJFAKTURE) values ('1','VAZIUZFAKTURU','2','1','1','1');
REM INSERTING into STEFAN.JEDINICAMERE
SET DEFINE OFF;
Insert into STEFAN.JEDINICAMERE (SIFRAJM,NAZIVJM) values ('1','KOM');
Insert into STEFAN.JEDINICAMERE (SIFRAJM,NAZIVJM) values ('2','KG');
Insert into STEFAN.JEDINICAMERE (SIFRAJM,NAZIVJM) values ('3','M');
REM INSERTING into STEFAN.JEDINSTVENACARINSKAISPRAVA
SET DEFINE OFF;
Insert into STEFAN.JEDINSTVENACARINSKAISPRAVA (REFERENTNIBROJ,DATUMJCI,OPIS,BROJFAKTURE,SIFRARADNIKA,SIFRAPP,SIFRAVALUTE,SIFRACARINARNICE) values ('1',to_date('31.03.2015','DD.MM.RRRR'),'OCARINJENO','1','1','1','2','1');
REM INSERTING into STEFAN.MESTO
SET DEFINE OFF;
Insert into STEFAN.MESTO (SIFRAMESTA,NAZIVMESTA,PTTBROJ) values ('1','BEOGRAD','11000');
Insert into STEFAN.MESTO (SIFRAMESTA,NAZIVMESTA,PTTBROJ) values ('2','NOVI SAD','21000');
Insert into STEFAN.MESTO (SIFRAMESTA,NAZIVMESTA,PTTBROJ) values ('3','TORINO','10156');
REM INSERTING into STEFAN.NARUDZBENICA
SET DEFINE OFF;
Insert into STEFAN.NARUDZBENICA (BROJNARUDZBENICE,DATUMNARUDZBENICE,DATUMDO,NAPOMENA,SIFRARADNIKA,SIFRAPP) values ('1',to_date('11.12.2014','DD.MM.RRRR'),to_date('13.02.2015','DD.MM.RRRR'),'STOPRE','1','1');
REM INSERTING into STEFAN.OBRACUNCARINSKOGDUGA
SET DEFINE OFF;
Insert into STEFAN.OBRACUNCARINSKOGDUGA (BROJOBRACUNA,DATUMOBRACUNA,NAPOMENA,REFERENTNIBROJ,SIFRARADNIKA,SIFRAPP,SIFRACARINARNICE) values ('1',to_date('31.03.2015','DD.MM.RRRR'),'OBRACUNCARINSKOGDUGAIZVRSENPREMAJCI','1','1','1','1');
REM INSERTING into STEFAN.POSLOVNIPARTNER
SET DEFINE OFF;
Insert into STEFAN.POSLOVNIPARTNER (SIFRAPP,NAZIVPP,TELEFON,FAX,EMAIL,SIFRAZEMLJE,SIFRADELATNOSTI,SIFRAMESTA,SIFRAULICE,BROJ,SPRAT,NAZIVDELATNOSTI) values ('1','SLODES','3512255','3512256','[email protected]','1','3','1','1','10','2','SPEDICIJA');
Insert into STEFAN.POSLOVNIPARTNER (SIFRAPP,NAZIVPP,TELEFON,FAX,EMAIL,SIFRAZEMLJE,SIFRADELATNOSTI,SIFRAMESTA,SIFRAULICE,BROJ,SPRAT,NAZIVDELATNOSTI) values ('2','IVECO','125401621','125401622','[email protected]','2','1','3','4','20','4','TRGOVINANAVELIKO');
REM INSERTING into STEFAN.RADNIK
SET DEFINE OFF;
Insert into STEFAN.RADNIK (SIFRARADNIKA,IMEPREZIME,TELEFON,JMBG) values ('1','JOVANJOVANOVIC','633322145','1201985710288');
Insert into STEFAN.RADNIK (SIFRARADNIKA,IMEPREZIME,TELEFON,JMBG) values ('2','PERAPERIC','692255146','2510965710298');
Insert into STEFAN.RADNIK (SIFRARADNIKA,IMEPREZIME,TELEFON,JMBG) values ('3','VENICPIRC','665252511','226316626462');
REM INSERTING into STEFAN.ROBA
SET DEFINE OFF;
Insert into STEFAN.ROBA (SIFRAROBE,NAZIVROBE,SIFRAJM) values ('1','KOMBI','1');
Insert into STEFAN.ROBA (SIFRAROBE,NAZIVROBE,SIFRAJM) values ('2','KAMION','1');
REM INSERTING into STEFAN.STAVKAJCI
SET DEFINE OFF;
Insert into STEFAN.STAVKAJCI (REFERENTNIBROJ,RBSTAVKEJCI,KOLICINA,BROJFAKTURE,RBSTAVKEFAKTURE) values ('1','1','1','1','1');
REM INSERTING into STEFAN.STAVKANARUDZBENICE
SET DEFINE OFF;
Insert into STEFAN.STAVKANARUDZBENICE (BROJNARUDZBENICE,RB,KOLICINA,SIFRAROBE,DATUMNARUDZBENICE) values ('1','1','1','1',to_date('11.12.2014','DD.MM.RRRR'));
REM INSERTING into STEFAN.STAVKAOCD
SET DEFINE OFF;
Insert into STEFAN.STAVKAOCD (BROJOBRACUNA,RBSTAVKEOCD,KOLICINA,REFERENTNIBROJ,RBSTAVKEJCI) values ('1','1','1','1','1');
REM INSERTING into STEFAN.STAVKEFAKTURE
SET DEFINE OFF;
Insert into STEFAN.STAVKEFAKTURE (BROJFAKTURE,RBSTAVKEFAKTURE,KOLICINA,BROJNARUDZBENICE,RB) values ('1','1','1','1','1');
REM INSERTING into STEFAN.TRANSPORTNOSREDSTVO
SET DEFINE OFF;
Insert into STEFAN.TRANSPORTNOSREDSTVO (SIFRATS,NAZIVTS,SIFRAVTS) values ('1','KAMIONSAPRIKOLICOM','1');
Insert into STEFAN.TRANSPORTNOSREDSTVO (SIFRATS,NAZIVTS,SIFRAVTS) values ('2','VOZ','2');
Insert into STEFAN.TRANSPORTNOSREDSTVO (SIFRATS,NAZIVTS,SIFRAVTS) values ('3','BROD','3');
Insert into STEFAN.TRANSPORTNOSREDSTVO (SIFRATS,NAZIVTS,SIFRAVTS) values ('4','AVION','4');
REM INSERTING into STEFAN.ULICA
SET DEFINE OFF;
Insert into STEFAN.ULICA (SIFRAULICE,NAZIVULICE) values ('1','BORSKA');
Insert into STEFAN.ULICA (SIFRAULICE,NAZIVULICE) values ('2','BEOGRADSKA');
Insert into STEFAN.ULICA (SIFRAULICE,NAZIVULICE) values ('3','VUKA KARADZICA');
Insert into STEFAN.ULICA (SIFRAULICE,NAZIVULICE) values ('4','VIA PUGILIA');
REM INSERTING into STEFAN.VALUTA
SET DEFINE OFF;
Insert into STEFAN.VALUTA (SIFRAVALUTE,NAZIVVALUTE) values ('1','EUR');
Insert into STEFAN.VALUTA (SIFRAVALUTE,NAZIVVALUTE) values ('2','DIN');
REM INSERTING into STEFAN.VRSTETRANSPORTNOGSREDSTVA
SET DEFINE OFF;
Insert into STEFAN.VRSTETRANSPORTNOGSREDSTVA (SIFRAVTS,NAZIVVTS) values ('1','KAMIONSAPRIKOLICOM');
Insert into STEFAN.VRSTETRANSPORTNOGSREDSTVA (SIFRAVTS,NAZIVVTS) values ('2','VOZ');
Insert into STEFAN.VRSTETRANSPORTNOGSREDSTVA (SIFRAVTS,NAZIVVTS) values ('3','BROD');
Insert into STEFAN.VRSTETRANSPORTNOGSREDSTVA (SIFRAVTS,NAZIVVTS) values ('4','AVION');
REM INSERTING into STEFAN.ZEMLJA
SET DEFINE OFF;
Insert into STEFAN.ZEMLJA (SIFRAZEMLJE,NAZIVZEMLJE) values ('1','BEOGRAD');
Insert into STEFAN.ZEMLJA (SIFRAZEMLJE,NAZIVZEMLJE) values ('2','ITALIJA');
--------------------------------------------------------
-- DDL for Index ULICA_PK
--------------------------------------------------------

CREATE UNIQUE INDEX "STEFAN"."ULICA_PK" ON "STEFAN"."ULICA" ("SIFRAULICE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index OBRACUN_PK
--------------------------------------------------------

CREATE UNIQUE INDEX "STEFAN"."OBRACUN_PK" ON "STEFAN"."OBRACUNCARINSKOGDUGA" ("BROJOBRACUNA")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index STFAKTURA_PK
--------------------------------------------------------

CREATE UNIQUE INDEX "STEFAN"."STFAKTURA_PK" ON "STEFAN"."STAVKEFAKTURE" ("BROJFAKTURE", "RBSTAVKEFAKTURE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index STAVKAJCI_PK
--------------------------------------------------------

CREATE UNIQUE INDEX "STEFAN"."STAVKAJCI_PK" ON "STEFAN"."STAVKAJCI" ("REFERENTNIBROJ", "RBSTAVKEJCI")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index PP_PK
--------------------------------------------------------

CREATE UNIQUE INDEX "STEFAN"."PP_PK" ON "STEFAN"."POSLOVNIPARTNER" ("SIFRAPP")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index MESTO_PK
--------------------------------------------------------

CREATE UNIQUE INDEX "STEFAN"."MESTO_PK" ON "STEFAN"."MESTO" ("SIFRAMESTA")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index IZJAVA_PK
--------------------------------------------------------

CREATE UNIQUE INDEX "STEFAN"."IZJAVA_PK" ON "STEFAN"."IZJAVADOVOZENJAVOZILA" ("SIFRAIZJAVE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index CENAROBA_PK
--------------------------------------------------------

CREATE UNIQUE INDEX "STEFAN"."CENAROBA_PK" ON "STEFAN"."CENAROBE" ("SIFRAROBE", "DATUMOD")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index VTS_PK
--------------------------------------------------------

CREATE UNIQUE INDEX "STEFAN"."VTS_PK" ON "STEFAN"."VRSTETRANSPORTNOGSREDSTVA" ("SIFRAVTS")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index OCD_PK
--------------------------------------------------------

CREATE UNIQUE INDEX "STEFAN"."OCD_PK" ON "STEFAN"."STAVKAOCD" ("BROJOBRACUNA", "RBSTAVKEOCD")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index ISPRAVA_PK
--------------------------------------------------------

CREATE UNIQUE INDEX "STEFAN"."ISPRAVA_PK" ON "STEFAN"."JEDINSTVENACARINSKAISPRAVA" ("REFERENTNIBROJ")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index RADNIK_PK
--------------------------------------------------------

CREATE UNIQUE INDEX "STEFAN"."RADNIK_PK" ON "STEFAN"."RADNIK" ("SIFRARADNIKA")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index VALUTA_PK
--------------------------------------------------------

CREATE UNIQUE INDEX "STEFAN"."VALUTA_PK" ON "STEFAN"."VALUTA" ("SIFRAVALUTE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index FAKTURA_PK
--------------------------------------------------------

CREATE UNIQUE INDEX "STEFAN"."FAKTURA_PK" ON "STEFAN"."FAKTURA" ("BROJFAKTURE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index ADRESA_PK
--------------------------------------------------------

CREATE UNIQUE INDEX "STEFAN"."ADRESA_PK" ON "STEFAN"."ADRESA" ("SIFRAMESTA", "SIFRAULICE", "BROJ", "SPRAT")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index ZEMLJA_PK
--------------------------------------------------------

CREATE UNIQUE INDEX "STEFAN"."ZEMLJA_PK" ON "STEFAN"."ZEMLJA" ("SIFRAZEMLJE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index DELATNOST_PK
--------------------------------------------------------

CREATE UNIQUE INDEX "STEFAN"."DELATNOST_PK" ON "STEFAN"."DELATNOST" ("SIFRADELATNOSTI")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index CARINARNICA_PK
--------------------------------------------------------

CREATE UNIQUE INDEX "STEFAN"."CARINARNICA_PK" ON "STEFAN"."CARINARNICA" ("SIFRACARINARNICE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index JM_PK
--------------------------------------------------------

CREATE UNIQUE INDEX "STEFAN"."JM_PK" ON "STEFAN"."JEDINICAMERE" ("SIFRAJM")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index TS_PK
--------------------------------------------------------

CREATE UNIQUE INDEX "STEFAN"."TS_PK" ON "STEFAN"."TRANSPORTNOSREDSTVO" ("SIFRATS")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index STNARUDZBENICE_PK
--------------------------------------------------------

CREATE UNIQUE INDEX "STEFAN"."STNARUDZBENICE_PK" ON "STEFAN"."STAVKANARUDZBENICE" ("BROJNARUDZBENICE", "RB")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index ROBA_PK
--------------------------------------------------------

CREATE UNIQUE INDEX "STEFAN"."ROBA_PK" ON "STEFAN"."ROBA" ("SIFRAROBE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- DDL for Index NARUDZBENICA_PK
--------------------------------------------------------

CREATE UNIQUE INDEX "STEFAN"."NARUDZBENICA_PK" ON "STEFAN"."NARUDZBENICA" ("BROJNARUDZBENICE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ;
--------------------------------------------------------
-- Constraints for Table VRSTETRANSPORTNOGSREDSTVA
--------------------------------------------------------

ALTER TABLE "STEFAN"."VRSTETRANSPORTNOGSREDSTVA" ADD CONSTRAINT "VTS_PK" PRIMARY KEY ("SIFRAVTS")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."VRSTETRANSPORTNOGSREDSTVA" MODIFY ("SIFRAVTS" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table DELATNOST
--------------------------------------------------------

ALTER TABLE "STEFAN"."DELATNOST" ADD CONSTRAINT "DELATNOST_PK" PRIMARY KEY ("SIFRADELATNOSTI")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."DELATNOST" MODIFY ("SIFRADELATNOSTI" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table POSLOVNIPARTNER
--------------------------------------------------------

ALTER TABLE "STEFAN"."POSLOVNIPARTNER" ADD CONSTRAINT "PP_PK" PRIMARY KEY ("SIFRAPP")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."POSLOVNIPARTNER" MODIFY ("SIFRAPP" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table ZEMLJA
--------------------------------------------------------

ALTER TABLE "STEFAN"."ZEMLJA" ADD CONSTRAINT "ZEMLJA_PK" PRIMARY KEY ("SIFRAZEMLJE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."ZEMLJA" MODIFY ("SIFRAZEMLJE" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table ULICA
--------------------------------------------------------

ALTER TABLE "STEFAN"."ULICA" ADD CONSTRAINT "ULICA_PK" PRIMARY KEY ("SIFRAULICE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."ULICA" MODIFY ("SIFRAULICE" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table ROBA
--------------------------------------------------------

ALTER TABLE "STEFAN"."ROBA" ADD CONSTRAINT "ROBA_PK" PRIMARY KEY ("SIFRAROBE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."ROBA" MODIFY ("SIFRAROBE" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table FAKTURA
--------------------------------------------------------

ALTER TABLE "STEFAN"."FAKTURA" ADD CONSTRAINT "FAKTURA_PK" PRIMARY KEY ("BROJFAKTURE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."FAKTURA" MODIFY ("BROJFAKTURE" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table STAVKEFAKTURE
--------------------------------------------------------

ALTER TABLE "STEFAN"."STAVKEFAKTURE" ADD CONSTRAINT "STFAKTURA_PK" PRIMARY KEY ("BROJFAKTURE", "RBSTAVKEFAKTURE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."STAVKEFAKTURE" MODIFY ("BROJFAKTURE" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table JEDINSTVENACARINSKAISPRAVA
--------------------------------------------------------

ALTER TABLE "STEFAN"."JEDINSTVENACARINSKAISPRAVA" ADD CONSTRAINT "ISPRAVA_PK" PRIMARY KEY ("REFERENTNIBROJ")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."JEDINSTVENACARINSKAISPRAVA" MODIFY ("REFERENTNIBROJ" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table RADNIK
--------------------------------------------------------

ALTER TABLE "STEFAN"."RADNIK" ADD CONSTRAINT "RADNIK_PK" PRIMARY KEY ("SIFRARADNIKA")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."RADNIK" MODIFY ("SIFRARADNIKA" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table NARUDZBENICA
--------------------------------------------------------

ALTER TABLE "STEFAN"."NARUDZBENICA" ADD CONSTRAINT "NARUDZBENICA_PK" PRIMARY KEY ("BROJNARUDZBENICE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."NARUDZBENICA" MODIFY ("BROJNARUDZBENICE" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CARINARNICA
--------------------------------------------------------

ALTER TABLE "STEFAN"."CARINARNICA" ADD CONSTRAINT "CARINARNICA_PK" PRIMARY KEY ("SIFRACARINARNICE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."CARINARNICA" MODIFY ("SIFRACARINARNICE" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table ADRESA
--------------------------------------------------------

ALTER TABLE "STEFAN"."ADRESA" ADD CONSTRAINT "ADRESA_PK" PRIMARY KEY ("SIFRAMESTA", "SIFRAULICE", "BROJ", "SPRAT")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."ADRESA" MODIFY ("SIFRAMESTA" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table STAVKAJCI
--------------------------------------------------------

ALTER TABLE "STEFAN"."STAVKAJCI" ADD CONSTRAINT "STAVKAJCI_PK" PRIMARY KEY ("REFERENTNIBROJ", "RBSTAVKEJCI")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."STAVKAJCI" MODIFY ("REFERENTNIBROJ" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table CENAROBE
--------------------------------------------------------

ALTER TABLE "STEFAN"."CENAROBE" ADD CONSTRAINT "CENAROBA_PK" PRIMARY KEY ("SIFRAROBE", "DATUMOD")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."CENAROBE" MODIFY ("SIFRAROBE" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table OBRACUNCARINSKOGDUGA
--------------------------------------------------------

ALTER TABLE "STEFAN"."OBRACUNCARINSKOGDUGA" ADD CONSTRAINT "OBRACUN_PK" PRIMARY KEY ("BROJOBRACUNA")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."OBRACUNCARINSKOGDUGA" MODIFY ("BROJOBRACUNA" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table VALUTA
--------------------------------------------------------

ALTER TABLE "STEFAN"."VALUTA" ADD CONSTRAINT "VALUTA_PK" PRIMARY KEY ("SIFRAVALUTE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."VALUTA" MODIFY ("SIFRAVALUTE" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table IZJAVADOVOZENJAVOZILA
--------------------------------------------------------

ALTER TABLE "STEFAN"."IZJAVADOVOZENJAVOZILA" ADD CONSTRAINT "IZJAVA_PK" PRIMARY KEY ("SIFRAIZJAVE")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."IZJAVADOVOZENJAVOZILA" MODIFY ("SIFRAIZJAVE" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table TRANSPORTNOSREDSTVO
--------------------------------------------------------

ALTER TABLE "STEFAN"."TRANSPORTNOSREDSTVO" ADD CONSTRAINT "TS_PK" PRIMARY KEY ("SIFRATS")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."TRANSPORTNOSREDSTVO" MODIFY ("SIFRATS" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table STAVKAOCD
--------------------------------------------------------

ALTER TABLE "STEFAN"."STAVKAOCD" ADD CONSTRAINT "OCD_PK" PRIMARY KEY ("BROJOBRACUNA", "RBSTAVKEOCD")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."STAVKAOCD" MODIFY ("BROJOBRACUNA" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table STAVKANARUDZBENICE
--------------------------------------------------------

ALTER TABLE "STEFAN"."STAVKANARUDZBENICE" ADD CONSTRAINT "STNARUDZBENICE_PK" PRIMARY KEY ("BROJNARUDZBENICE", "RB")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."STAVKANARUDZBENICE" MODIFY ("BROJNARUDZBENICE" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table JEDINICAMERE
--------------------------------------------------------

ALTER TABLE "STEFAN"."JEDINICAMERE" ADD CONSTRAINT "JM_PK" PRIMARY KEY ("SIFRAJM")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."JEDINICAMERE" MODIFY ("SIFRAJM" NOT NULL ENABLE);
--------------------------------------------------------
-- Constraints for Table MESTO
--------------------------------------------------------

ALTER TABLE "STEFAN"."MESTO" ADD CONSTRAINT "MESTO_PK" PRIMARY KEY ("SIFRAMESTA")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSTEM" ENABLE;
ALTER TABLE "STEFAN"."MESTO" MODIFY ("SIFRAMESTA" NOT NULL ENABLE);
--------------------------------------------------------
-- Ref Constraints for Table ADRESA
--------------------------------------------------------

ALTER TABLE "STEFAN"."ADRESA" ADD CONSTRAINT "ADRESA_FK1" FOREIGN KEY ("SIFRAMESTA")
REFERENCES "STEFAN"."MESTO" ("SIFRAMESTA") ENABLE;
ALTER TABLE "STEFAN"."ADRESA" ADD CONSTRAINT "ADRESA_FK2" FOREIGN KEY ("SIFRAULICE")
REFERENCES "STEFAN"."ULICA" ("SIFRAULICE") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table CENAROBE
--------------------------------------------------------

ALTER TABLE "STEFAN"."CENAROBE" ADD CONSTRAINT "CENAROBA_FK" FOREIGN KEY ("SIFRAROBE")
REFERENCES "STEFAN"."ROBA" ("SIFRAROBE") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table FAKTURA
--------------------------------------------------------

ALTER TABLE "STEFAN"."FAKTURA" ADD CONSTRAINT "FAKTURA_FK1" FOREIGN KEY ("SIFRARADNIKA")
REFERENCES "STEFAN"."RADNIK" ("SIFRARADNIKA") ENABLE;
ALTER TABLE "STEFAN"."FAKTURA" ADD CONSTRAINT "FAKTURA_FK2" FOREIGN KEY ("SIFRAPP")
REFERENCES "STEFAN"."POSLOVNIPARTNER" ("SIFRAPP") ENABLE;
ALTER TABLE "STEFAN"."FAKTURA" ADD CONSTRAINT "FAKTURA_FK3" FOREIGN KEY ("SIFRAVALUTE")
REFERENCES "STEFAN"."VALUTA" ("SIFRAVALUTE") ENABLE;
ALTER TABLE "STEFAN"."FAKTURA" ADD CONSTRAINT "FAKTURA_FK4" FOREIGN KEY ("BROJNARUDZBENICE")
REFERENCES "STEFAN"."NARUDZBENICA" ("BROJNARUDZBENICE") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table IZJAVADOVOZENJAVOZILA
--------------------------------------------------------

ALTER TABLE "STEFAN"."IZJAVADOVOZENJAVOZILA" ADD CONSTRAINT "IZJAVA_FK1" FOREIGN KEY ("SIFRARADNIKA")
REFERENCES "STEFAN"."RADNIK" ("SIFRARADNIKA") ENABLE;
ALTER TABLE "STEFAN"."IZJAVADOVOZENJAVOZILA" ADD CONSTRAINT "IZJAVA_FK2" FOREIGN KEY ("SIFRATS")
REFERENCES "STEFAN"."TRANSPORTNOSREDSTVO" ("SIFRATS") ENABLE;
ALTER TABLE "STEFAN"."IZJAVADOVOZENJAVOZILA" ADD CONSTRAINT "IZJAVA_FK3" FOREIGN KEY ("SIFRAPP")
REFERENCES "STEFAN"."POSLOVNIPARTNER" ("SIFRAPP") ENABLE;
ALTER TABLE "STEFAN"."IZJAVADOVOZENJAVOZILA" ADD CONSTRAINT "IZJAVA_FK4" FOREIGN KEY ("BROJFAKTURE")
REFERENCES "STEFAN"."FAKTURA" ("BROJFAKTURE") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table JEDINSTVENACARINSKAISPRAVA
--------------------------------------------------------

ALTER TABLE "STEFAN"."JEDINSTVENACARINSKAISPRAVA" ADD CONSTRAINT "ISPRAVA_FK1" FOREIGN KEY ("BROJFAKTURE")
REFERENCES "STEFAN"."FAKTURA" ("BROJFAKTURE") ENABLE;
ALTER TABLE "STEFAN"."JEDINSTVENACARINSKAISPRAVA" ADD CONSTRAINT "ISPRAVA_FK2" FOREIGN KEY ("SIFRARADNIKA")
REFERENCES "STEFAN"."RADNIK" ("SIFRARADNIKA") ENABLE;
ALTER TABLE "STEFAN"."JEDINSTVENACARINSKAISPRAVA" ADD CONSTRAINT "ISPRAVA_FK3" FOREIGN KEY ("SIFRAPP")
REFERENCES "STEFAN"."POSLOVNIPARTNER" ("SIFRAPP") ENABLE;
ALTER TABLE "STEFAN"."JEDINSTVENACARINSKAISPRAVA" ADD CONSTRAINT "ISPRAVA_FK4" FOREIGN KEY ("SIFRAVALUTE")
REFERENCES "STEFAN"."VALUTA" ("SIFRAVALUTE") ENABLE;
ALTER TABLE "STEFAN"."JEDINSTVENACARINSKAISPRAVA" ADD CONSTRAINT "ISPRAVA_FK5" FOREIGN KEY ("SIFRACARINARNICE")
REFERENCES "STEFAN"."CARINARNICA" ("SIFRACARINARNICE") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table NARUDZBENICA
--------------------------------------------------------

ALTER TABLE "STEFAN"."NARUDZBENICA" ADD CONSTRAINT "NARUDZBENICA_FK1" FOREIGN KEY ("SIFRARADNIKA")
REFERENCES "STEFAN"."RADNIK" ("SIFRARADNIKA") ENABLE;
ALTER TABLE "STEFAN"."NARUDZBENICA" ADD CONSTRAINT "NARUDZBENICA_FK2" FOREIGN KEY ("SIFRAPP")
REFERENCES "STEFAN"."POSLOVNIPARTNER" ("SIFRAPP") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table OBRACUNCARINSKOGDUGA
--------------------------------------------------------

ALTER TABLE "STEFAN"."OBRACUNCARINSKOGDUGA" ADD CONSTRAINT "OBRACUN_FK1" FOREIGN KEY ("REFERENTNIBROJ")
REFERENCES "STEFAN"."JEDINSTVENACARINSKAISPRAVA" ("REFERENTNIBROJ") ENABLE;
ALTER TABLE "STEFAN"."OBRACUNCARINSKOGDUGA" ADD CONSTRAINT "OBRACUN_FK2" FOREIGN KEY ("SIFRARADNIKA")
REFERENCES "STEFAN"."RADNIK" ("SIFRARADNIKA") ENABLE;
ALTER TABLE "STEFAN"."OBRACUNCARINSKOGDUGA" ADD CONSTRAINT "OBRACUN_FK3" FOREIGN KEY ("SIFRAPP")
REFERENCES "STEFAN"."POSLOVNIPARTNER" ("SIFRAPP") ENABLE;
ALTER TABLE "STEFAN"."OBRACUNCARINSKOGDUGA" ADD CONSTRAINT "OBRACUN_FK4" FOREIGN KEY ("SIFRACARINARNICE")
REFERENCES "STEFAN"."CARINARNICA" ("SIFRACARINARNICE") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table POSLOVNIPARTNER
--------------------------------------------------------

ALTER TABLE "STEFAN"."POSLOVNIPARTNER" ADD CONSTRAINT "PP_FK1" FOREIGN KEY ("SIFRAZEMLJE")
REFERENCES "STEFAN"."ZEMLJA" ("SIFRAZEMLJE") ENABLE;
ALTER TABLE "STEFAN"."POSLOVNIPARTNER" ADD CONSTRAINT "PP_FK2" FOREIGN KEY ("SIFRADELATNOSTI")
REFERENCES "STEFAN"."DELATNOST" ("SIFRADELATNOSTI") ENABLE;
ALTER TABLE "STEFAN"."POSLOVNIPARTNER" ADD CONSTRAINT "PP_FK3" FOREIGN KEY ("SIFRAMESTA", "SIFRAULICE", "BROJ", "SPRAT")
REFERENCES "STEFAN"."ADRESA" ("SIFRAMESTA", "SIFRAULICE", "BROJ", "SPRAT") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table ROBA
--------------------------------------------------------

ALTER TABLE "STEFAN"."ROBA" ADD CONSTRAINT "ROBA_FK" FOREIGN KEY ("SIFRAJM")
REFERENCES "STEFAN"."JEDINICAMERE" ("SIFRAJM") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table STAVKAJCI
--------------------------------------------------------

ALTER TABLE "STEFAN"."STAVKAJCI" ADD CONSTRAINT "STAVKEJCI_FK1" FOREIGN KEY ("BROJFAKTURE", "RBSTAVKEFAKTURE")
REFERENCES "STEFAN"."STAVKEFAKTURE" ("BROJFAKTURE", "RBSTAVKEFAKTURE") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table STAVKANARUDZBENICE
--------------------------------------------------------

ALTER TABLE "STEFAN"."STAVKANARUDZBENICE" ADD CONSTRAINT "STNARUDZBENICE_FK1" FOREIGN KEY ("SIFRAROBE")
REFERENCES "STEFAN"."ROBA" ("SIFRAROBE") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table STAVKAOCD
--------------------------------------------------------

ALTER TABLE "STEFAN"."STAVKAOCD" ADD CONSTRAINT "OCD_FK1" FOREIGN KEY ("BROJOBRACUNA")
REFERENCES "STEFAN"."OBRACUNCARINSKOGDUGA" ("BROJOBRACUNA") ENABLE;
ALTER TABLE "STEFAN"."STAVKAOCD" ADD CONSTRAINT "OCD_FK2" FOREIGN KEY ("REFERENTNIBROJ", "RBSTAVKEJCI")
REFERENCES "STEFAN"."STAVKAJCI" ("REFERENTNIBROJ", "RBSTAVKEJCI") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table STAVKEFAKTURE
--------------------------------------------------------

ALTER TABLE "STEFAN"."STAVKEFAKTURE" ADD CONSTRAINT "STFAKTURA_FK1" FOREIGN KEY ("BROJNARUDZBENICE", "RB")
REFERENCES "STEFAN"."STAVKANARUDZBENICE" ("BROJNARUDZBENICE", "RB") ENABLE;
--------------------------------------------------------
-- Ref Constraints for Table TRANSPORTNOSREDSTVO
--------------------------------------------------------

ALTER TABLE "STEFAN"."TRANSPORTNOSREDSTVO" ADD CONSTRAINT "TS_FK1" FOREIGN KEY ("SIFRAVTS")
REFERENCES "STEFAN"."VRSTETRANSPORTNOGSREDSTVA" ("SIFRAVTS") ENABLE;
 
Odgovor na temu

savkic
Igor Savkić

Moderator
Član broj: 92186
Poruke: 2628



+69 Profil

icon Re: Delphi 7 i Oracle24.02.2016. u 17:32 - pre 53 meseci
> Ono sto meni treba jeste da napravim aplikaciju,koja bi ucitala to iz sql.file...

Vrlo si nejasan tako da odgovor može biti ali i ne ono što tražiš.

> Kda otvorim to pomocu notepad vidim sql jezik,za pravljenje tabela,polja i slicno...U stvari,evo prekopiracu,sta mi je u njemu...

To je SQL skript za definiciju baze, ne znam koju bazu koristiš ali svaka ima neki alat (command line ili GUI) za izvršavanje skriptova, prosto pronadji koji je to alat u toj bazi i vidi kako se neki skript fajl može izvršiti.

 
Odgovor na temu

popmilan76
Programer

Član broj: 295089
Poruke: 1153
*.dynamic.isp.telekom.rs.



+4 Profil

icon Re: Delphi 7 i Oracle24.02.2016. u 17:41 - pre 53 meseci
Problem je,jer ni ja ne znam to da objasnim,iskreno....treba da povezem aplikaciju sa ovom skriptom,iscitam podatke i eventualno nesto dodam...
 
Odgovor na temu

djoka_l
Beograd

Član broj: 56075
Poruke: 2861



+1162 Profil

icon Re: Delphi 7 i Oracle24.02.2016. u 20:50 - pre 53 meseci
To što si stavio jeste sql skripta koja je verovatno generisana iz nekog alata i odnosi se na kreiranje objekata i popunjavanje podataka za Oracle bazu (to se vidi po storage opcijama, definitvno Oracle).

Skripta prvo briše (radi DROP) 23 tabele iz šeme "STEFAN", rekreira te tabele, puni ih nekim podacima, pa onda rekreira PK i FK nad tabelama.

Sada, nemam pojma šta tebi treba - iščitaj podatke i nešto eventualno dodaj. Kakvo pitanje, takav i odgovor...
 
Odgovor na temu

popmilan76
Programer

Član broj: 295089
Poruke: 1153
*.dynamic.isp.telekom.rs.



+4 Profil

icon Re: Delphi 7 i Oracle24.02.2016. u 21:56 - pre 53 meseci
Pitanje je kako iscitati podatke iz te tabele....
 
Odgovor na temu

salvaric
Novi Sad

Član broj: 53995
Poruke: 192
*.dynamic.sbb.rs.



+4 Profil

icon Re: Delphi 7 i Oracle24.02.2016. u 22:09 - pre 53 meseci
Skripta nije baza podataka i u njoj se ne nalaze podaci kojima ti možeš pristupiti iz aplikacija u vidu tabele ili bilo čega sa nekom alatkom. Mislim da mešaš babe i žabe.

U ovom tvom slučaju je Oracle baza podataka koju moraš imati instaliranu na kompu, i u nju implementirati .sql skriptu sa nekim alatom (nisam radio sa Oracle ali je gore navedeno da možeš pristupiti pomoću ADO komponenti) koja će kreirati tabele i njene strukture. Tek nakon toga ćeš moći pristupiti tabelama i njenim slogovima sa Query ili Table komponentama, kako bi ih mogao menjati, prikazivati itd...


Nikad izvini!
 
Odgovor na temu

djoka_l
Beograd

Član broj: 56075
Poruke: 2861



+1162 Profil

icon Re: Delphi 7 i Oracle24.02.2016. u 22:11 - pre 53 meseci
Tabele ne postoje.
Podaci se nalaze u insert naredbama, polja se nalaze u create table naredbama. Ako nemaš Oracle bazu, nemaš tabele.
1. Instaliraj Oracle
2. kreiraj korisnika STEFAN i daj mu pravo da kreira tabele (resource privilegiju nad nekim tablespace)
3. pusti skript (iz alata kao što je SQL*Plus koji dobijaš uz Oracle, ili iz nekog drugog alata kao što je SQL Developer, PLSQL Developer, TOAD, ...)
4. napiši program koji će da radi select/insert/update

ili

1. prepravi sql skript da bude sintaksno ispravan u tvojoj omiljenoj bazi.
2. pusti skript
3. napiši program koji će da radi select/insert/update

ili

napravi od insert naredbi u svom omiljenom editoru csv fajlove pa ih učitaj u excel, a onda radi šta hoćeš u excelu

ili

napravi od insert naredbi u tvom omiljenom editoru gole podatke u formatu koji ti je zgodan za čitanje i učitaj ih.


[Ovu poruku je menjao djoka_l dana 24.02.2016. u 23:24 GMT+1]
 
Odgovor na temu

popmilan76
Programer

Član broj: 295089
Poruke: 1153
*.dynamic.isp.telekom.rs.



+4 Profil

icon Re: Delphi 7 i Oracle24.02.2016. u 22:24 - pre 53 meseci
To me zanima,ako bih i radio sa ovom skriptom,moram imati instaliran Oracle...Mislio sam da bi eventualno pomogli neki drajveri,da ne moram instalirati ceo Oracle....
 
Odgovor na temu

popmilan76
Programer

Član broj: 295089
Poruke: 1153
*.dynamic.isp.telekom.rs.



+4 Profil

icon Re: Delphi 7 i Oracle25.02.2016. u 10:28 - pre 53 meseci
Jel moguce pokrenuti ovu skriptu pomocu ado-a ili ne?Dakle bez instaliranja Oracle?
 
Odgovor na temu

captPicard
programer
more i planine

Član broj: 216084
Poruke: 1119



+19 Profil

icon Re: Delphi 7 i Oracle25.02.2016. u 10:36 - pre 53 meseci
Ta skripta ti je obicna tekstualna fajla. Ako ne zelis oracle prepravi ju da je mozea izvrsiti na bazi koju ti preferiras. Kolega ti je gore objasnio sve mogucnosti.
F
 
Odgovor na temu

popmilan76
Programer

Član broj: 295089
Poruke: 1153
*.dynamic.isp.telekom.rs.



+4 Profil

icon Re: Delphi 7 i Oracle25.02.2016. u 10:49 - pre 53 meseci
Mora biti u Oracle...ali mi nije jasno kako da izvrsim to,a nisam nikada radio sa serverom....sve je bilo lokalno....
 
Odgovor na temu

[es] :: Pascal / Delphi / Kylix :: Delphi 7 i Oracle

[ Pregleda: 2005 | Odgovora: 16 ] > FB > Twit

Postavi temu Odgovori

Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.