· 6 years ago · May 18, 2019, 11:42 AM
1DROP TABLE Client CASCADE CONSTRAINTS
2/
3DROP TABLE Comanda CASCADE CONSTRAINTS
4/
5DROP TABLE IstoricComenzi CASCADE CONSTRAINTS
6/
7DROP TABLE Plata CASCADE CONSTRAINTS
8/
9DROP TABLE Angajat CASCADE CONSTRAINTS
10/
11DROP TABLE Livrare CASCADE CONSTRAINTS
12/
13DROP TABLE Mancare CASCADE CONSTRAINTS
14/
15DROP TABLE Meniu CASCADE CONSTRAINTS
16/
17DROP TABLE Produs CASCADE CONSTRAINTS
18/
19DROP TABLE Stoc CASCADE CONSTRAINTS
20/
21
22create table Client (
23 IDClient int not null primary key,
24 Nume varchar2(30) not null,
25 Prenume varchar2(40) not null,
26 Email varchar2(50) not null,
27 Telefon varchar2(10),
28 Strada varchar2(50),
29 NumarStrada number(3),
30 created_at date,
31 updated_at date
32 )
33/
34
35create table Meniu (
36 IDMeniu number(2) not null primary key,
37 Nume varchar2(20) not null,
38 created_at date,
39 updated_at date
40)
41/
42
43create table Mancare (
44 IDMancare number(2) not null primary key,
45 Nume varchar2(30) not null,
46 Pret number(3) not null,
47 id_meniu number(2) not null,
48 created_at date,
49 updated_at date,
50 constraint fk_mancare_id_meniu foreign key (id_meniu) references Meniu(IDMeniu)
51)
52/
53
54create table Comanda (
55 IDComanda number(7) not null primary key,
56 DataComanda date not null,
57 StatusComanda varchar2(20) not null,
58 Cantitate number(2) not null,
59 id_client int not null,
60 id_mancare number(2) not null,
61 created_at date,
62 updated_at date,
63 constraint fk_comanda_id_client foreign key (id_client) references Client(IDClient),
64 constraint fk_comanda_id_mancare foreign key (id_mancare) references Mancare(IDMancare)
65)
66/
67
68create table IstoricComenzi (
69 IDIstroric number(7) not null primary key,
70 id_client int not null,
71 id_comanda number(7) not null,
72 created_at date,
73 updated_at date,
74 constraint fk_istoric_comenzi_id_client foreign key (id_client) references Client(IDClient)
75)
76/
77
78create table Plata (
79 IDPlata number(7) not null primary key,
80 Suma int not null,
81 TipPlata varchar2(5) not null,
82 DataPlata date not null,
83 id_comanda number(7) not null,
84 created_at date,
85 updated_at date,
86 constraint fk_plata_id_comanda foreign key (id_comanda) references Comanda(IDComanda)
87)
88/
89
90create table Angajat (
91 IDAngajat number(2) not null primary key,
92 Nume varchar2(30) not null,
93 Prenume varchar2(40) not null,
94 StatusAngajat varchar2(10) not null,
95 TimpPlecare date,
96 TimpSosire date,
97 created_at date,
98 updated_at date
99)
100/
101
102create table Livrare (
103 IDLivrare number(7) not null primary key,
104 id_comanda number(7) not null,
105 id_angajat number(2) not null,
106 created_at date,
107 updated_at date,
108 constraint fk_livrare_id_comanda foreign key (id_comanda) references Comanda(IDComanda),
109 constraint fk_livrare_id_angajat foreign key (id_angajat) references Angajat(IDAngajat)
110)
111/
112
113create table Stoc (
114 IDStocProdus number(3) not null primary key,
115 Nume varchar2(30) not null,
116 CantitateProdus number(3) not null,
117 created_at date,
118 updated_at date
119)
120/
121
122create table Produs (
123 IDProdus number(3) not null primary key,
124 id_mancare number(2) not null,
125 id_stoc_produs number(3) not null,
126 created_at date,
127 updated_at date,
128 constraint fk_produs_id_mancare foreign key (id_mancare) references Mancare(IDMancare),
129 constraint fk_produs_id_stoc_produs foreign key (id_stoc_produs) references Stoc(IDStocProdus)
130)
131/
132
133set serveroutput on;
134declare
135 type vector is varray(1250) of varchar2(256);
136 lista_nume vector := vector('Abaza','Adamache','Adamescu','Adamesteanu','Aderca','Adoc','Afrim','Agaparian','Agarbiceanu','Agirbiceanu','Albu','Albulescu','Aldulescu','Alexa','Alexandrescu','Alexe','Alexi','Alifantis','Almasan','Almas','Aman','Amanar','Andoni','Andreoiu','Andries','Andronic','Angelescu','Anghel','Anghelescu','Anton','Antonescu','Apostu','Ardelean','Ardeleanu','Argesanu','Argetoianu','Arghezi','Armasescu','Arnautoiu','Arnautu','Arnautu','Asachi','Athanasiu','Averescu','Avramescu','Bacalbasa','Baciu','Baconschi','Baconski','Baconsky','Badarau','Badea','Badescu','Badulescu','Baghiu','Baicu','Balaceanu','Balan','Balanici','Balauru','Balosescu','Baltat','Banateanu','Banica','Banica','Banulescu','Baracci','Barboianu','Barbu','Barbuceanu','Barbulescu','Barca','Barcianu','Barlea','Barloiu','Barna','Barsanescu','Barzin','Basarabeanu','Batraneanu','Batrineanu','Bazon','Balasa','Balanescu','Basescu','Barladeanu','Becali','Becheru','Bechet','Beclean','Becsenescu','Bega','Begu','Bejenaru','Bejinariu','Belcot','Belgea','Belimace','Benga','Bengescu','Bentoiu','Bercea','Bercu','Berghianu','Berindei','Besoiu','Bibescu','Bichinet','Birlea','Birloiu','Bizau','Blaga','Bodescu','Bodiu','Bodiul','Bodnaras','Bogos','Bogza','Bolliac','Bonciu','Borascu','Borcea','Bordea','Boroianu','Bosanceanu','Bosinceanu','Bostina','Botean','Boteanu','Botescu','Botnari','Botnaru','Bozga','Bozga','Bragadiru','Braghis','Brancoveanu','Branescu','Branzan','Branzeu','Brasoveanu','Bratescu','Brates','Bratianu','Bratu','Brancusi','Breban','Brediceanu','Brega','Brendus','Brezeanu','Brinzan','Brosteanu','Brudascu','Brumaru','Bucur','Bucurescu','Budeanu','Budescu','Buhagiar','Buhus','Buia','Bujor','Bulacu','Bulgari','Bunea','Bunescu','Burada','Burca','Burcea','Burduja','Burdujan','Burghele','Burileanu','Burtea','Buruiana','Bus','Busila','Buteanu','Butnariu','Butnaru','Butoi','Buzatu','Buzdugan','Buzescu','Buzesti','Buzoianu','Camataru','Caciulescu','Cacoveanu','Cadantu','Caianu','Caileanu','Calimente','Calina','Calinescu','Calota','Calotescu','Calugareanu','Campeanu','Campineanu','Candea','Captaru','Caraciobanu','Caracostea','Carafoli','Caragiale','Caragiani','Caragiu','Caramitru','Caranfil','Caranica','Cardos','Carianopol','Carpinis','Cartan','Cartianu','Casapu','Casian','Casle','Cassanovschi','Cassian','Casu','Catargi','Catargiu','Catoiu','Catuneanu','Caus','Cazacu','Cazan','Ceausescu','Ceausu','Cebanu','Cebotari','Cehanu','Ceia','Celan','Celibidache','Cenusaru','Cepoi','Ceraceanu','Cernat','Cernat','Cernatescu','Cernaianu','Cernea','Cernescu','Cernovodeanu','Cesereanu','Chebac','Chelaru','Chelcea','Chendi','Chihaia','Chindris','Chinezu','Chintezanu','Chioreanu','Chira','Chirila','Chirilov','Chirnoaga','Chirtoaca','Chiru','Chitu','Ciceu','Cihac','Cimpoesu','Cindea','Cinteza','Cioaba','Cioaca','Cioban','Ciobanu','Ciocalteu','Ciocarlan','Cioculescu','Ciolan','Ciopraga','Cioranu','Cioranescu','Ciorbea','Ciorogariu','Cioroianu','Ciortea','Cipariu','Ciresanu','Ciubotaru','Ciubuc','Ciuca','Ciuceanu','Ciucurescu','Ciulei','Ciupe','Ciupercovici','Cimpineanu','Cleopa','Coanda','Cocea','Cochinescu','Cocos','Codreanu','Codrescu','Codrut','Cojoc','Cojocari','Cojocaru','Colceru','Colibasanu','Coltoiu','Coman','Comanescu','Comarnescu','Comanici','Combiescu','Comisel','Conea','Constantin','Constantinescu','Constantiniu','Corban','Corbea','Corbu','Cordos','Corduneanu','Corfanta','Cornea','Cornea','Corneanu','Cornescu','Corodeanu','Coroi','Coropcean','Corut','Corvin','Cosmescu','Cosmovici','Cosovei','Costea','Costiniu','Cosbuc','Coseriu','Coteanu','Cotescu','Covaci','Covaliu','Covataru','Cozacovici','Cozma','Craciun','Craciunescu','Craiu','Crainiceanu','Creanga','Cretu','Crisbasan','Cristea','Cristescu','Crisan','Croitor','Croitoru','Cucu','Culianu','Cuparencu','Cupcea','Cupsa','Cusin','Cuza','Damaschin','Danceanu','Danciu','Danciulescu','Danescu','Danisor','Dascalescu','Dascalu','Datcu','Gheorghe David','Davidovici','Daranuta','Deac','Dediu','Dejeu','De la Marina','Deleanu','Demetrescu','Derdena','Diaconu','Diculescu','Dinculeanu','Dinescu','Dinica','Dinicu','Dinu','Dinulescu','Dita','Djuvara','Dobra','Dobran','Dobrin','Dobrescu','Dobrincu','Dobritoiu','Dobrogeanu','Dobrogianu','Dobroiu','Dogariu','Dogaru','Doicaru','Doinas','Dolanescu','Dolgan','Dolha','Donici','Dontul','Dorneanu','Dorobantu','Dragan','Draganescu','Draganu','Draghiceanu','Draghicescu','Draghici','Draghincescu','Dragnea','Dragomirescu','Dragos','Dragu','Dragulescu','Dragus','Dragusanu','Draguseanu','Dragoi','Drosu','Druganescu','Ducas','Dugulescu','Dulgheru','Dumbraveanu','Dumitrescu','Dumitru','Dzitac','Edeleanu','Eliade','Eminescu','Enache','Ene','Enescu','Epureanu','Erbiceanu','Esanu','Esinencu','Fagaras','Fagarasanu','Familia Ratiu','Familia Trancu','Fatu','Frentiu','Fernic','Fieraru','Filimon','Filipescu','Filotti','Finiti','Firulescu','Flondor','Florea','Florescu','Florianu','Fluieras','Foarta','Focsaneanu','Focsanu','Focseneanu','Focsineanu','Fotino','Fratila','Frosin','Frunda','Fugaru','Fulga','Gafita','Gaitan','Galatanu','Galeriu','Ganea','Gavanescu','Gaina','Ganescu','Geambasu','Geiculescu','Georgescu','Gheorghe','Gheorghelas','Gheorghilas','Gheorghiu','Gherghel','Gherghescu','Ghideanu','Ghinea','Ghita','Ghizari','Gigurtu','Gingaras','Giosanu','Giurescu','Gliga','Gligor','Glogoveanu','Goanta','Godea','Goga','Goian','Gojdu','Gojnea','Goldis','Goma','Gondi','Gozsdu','Gradisteanu','Grebencea','Greceanu','Grecescu','Grecu','Grigorescu','Grigoriu','Grindea','Gritti','Grosescu','Grosescu','Grosu','Groza','Grozescu','Gruia','Gruia','Gruiescu','Guci','Gulian','Gusa','Gusatu','Gutiu','Gutu','Hagi','Halep','Halippa','Hanganu','Hanu','Hasdeu','Hatieganu','Herescu','Herlea','Hermeneanu','Herta','Hertza','Hetco','Hirtea','Hoban','Hodorogea','Hodos','Hodos','Holda','Honcescu','Hossu','Hrisoverghi','Hristu','Huidu','Huniade','Hurezeanu','Hurmuzescu','Iacobescu','Iaru','Ierunca','Iliescu','Inculet','Ionel','Ionesco','Ionescu','Ionica','Ionita','Iordache','Iordachescu','Iovita','Iovit','Irimescu','Irimia','Irimie','Isopescu','Ispas','Istrati','Ivanceanu','Ivanescu','Ivascu','Ivasiuc','Izbasa','Jean','Jebeleanu','Joldea','Josan','Jumanca','Kiazim','Kiritescu','Kogalniceanu','Lacatus','Lacusta','Lahovary','Lambru','Lascar','Lascu','Laurian','Lazareanu','Lazu','Lazureanu','Lazarescu','Leca','Lecca','Lepadatu','Liiceanu','Lincar','Lipa','Lipatti','Livescu','Livezeanu','Logothetti','Loghin','Loteanu','Lotru','Lovinescu','Lubanovici','Luca','Lucaciu','Lucan','Lucescu','Luchian','Lugojan','Lugojanu','Lungu','Lup','Lupan','Lupascu','Lupea','Lupescu','Lupu','Lupu','Lupul','Lupulescu','Luputiu','Manea','Macovei','Macri','Magheru','Magureanu','Maican','Mailat','Malancioiu','Malcoci','Malutan','Manciulea','Manea','Manescu','Manicatide','Manoila','Manole','Manolescu','Mantog','Maracuta','Marascu','Marasescu','Marchitan','Mardare','Marginean','Margineanu','Marin','Marinescu','Marioteanu','Mavrodin','Mazarachi','Mazilu','Margineanu','Medeleanu','Melescanu','Melinte','Miclaus','Micle','Miclea','Miclescu','Miculescu','Mihaescu','Mihaileanu','Mihaita','Mihaiu','Mihalache','Mihaila','Mihailescu','Mihnea','Minovici','Mircea','Mironescu','Misu','Mitu','Mitu','Mocanescu','Mocanu','Moceanu','Mocioni','Moculescu','Modorcea','Möller','Mogos','Mois','Moldovan','Moldoveanu','Morar','Morosanu','Mortun','Moscopol','Moscovici','Motis','Motoc','Motoc','Motrescu','Mota','Movila','Movileanu','Mugur','Muntean','Munteanu','Murafa','Murarescu','Muraru','Muresanu','Muresan','Murgeanu','Murgescu','Murgoci','Murgulet','Murnu','Musat','Muscalu','Musca','Naghi','Nastase','Neacsu','Neaga','Neagoe','Neagu','Neamtu','Necula','Neculai','Neculce','Negoita','Negoitescu','Negrea','Negreanu','Negrescu','Negru','Nemescu','Nenita','Nica','Nicoara','Nicolaescu','Nicolaie','Nicolau','Nicolescu','Nicu','Niculae','Niculescu','Nicusor','Nistor','Nita','Nitescu','Noica','Notara','Nottara','Oancea','Odobescu','Oeriu','Ogararu','Oisteanu','Olanescu','Olari','Olariu','Olaru','Olinescu','Oltean','Olteanu','Onaca','Onciu','Onoriu','Oprea','Oprescu','Opris','Oprisan','Orasan','Orasan','Orasanu','Orascu','Orasean','Oraseanu','Orleanu','Ornea','Oroveanu','Pacepa','Paclisan','Paclisanu','Pacurariu','Pacuraru','Padurariu','Paduraru','Padureanu','Paduretu','Paduretu','Panaitescu','Pana','Pangrati','Panturu','Papacioc','Papacostea','Papahagi','Papura','Parascan','Parghel','Parizescu','Partos','Parvu','Pascali','Pascaly','Pascanu','Pascu','Paslaru','Pastia','Pascu','Patras','Patrascu','Patriciu','Patrut','Paun','Drumur','Pavelescu','Paturica','Paun','Paunescu','Parvulescu','Pella','Pellea','Penescu','Pescaru','Petcu','Petrascu','Petre','Petrescu','Petriceicu','Petrut','Picior','Piersic','Pietraru','Pintilie','Pislaru','Pitulea','Piturca','Plesan','Ploesteanu','Ploiesteanu','Podoleanu','Podriga','Poenaru','Poghirc','Pogonat','Pogoneanu','Pogor','Poienaru','Pomut','Pop','Popa','Popea','Popescu','Popovici','Popoviciu','Poroineanu','Porumbescu','Posea','Posteuca','Postolache','Preda','Predescu','Predoiu','Prelipceanu','Preoteasa','Proca','Procopie','Procopovici','Puiu','Purcarete','Puscariu','Puscas','Puscasu','Puşcaşu','Puturi','Raceanu','Racoti','Racoveanu','Racovita','Radescu','Radoi','Radovanu','Radovici','Radu','Raducan','Raducanu','Raducioiu','Raduta','Rapeanu','Ratiu','Razvan','Radulescu','Rebengiuc','Rebreanu','Ressu','Ripa','Ripeanu','Roata','Robu','Rogoz','Romanescu','Rosetti','Rosca','Rotariu','Rotaru','Rudeanu','Runceanu','Rus','Rus','Rusanu','Rusca','Rusescu','Russo','Rusu','Sabau','Sachelarie','Sadoveanu','Sahleanu','saineanu','Sanatescu','sandru','Sandu','Sanmartean','Sarateanu','Sarghie','Sasu','Satmareanu','Saulescu','Savescu','Savin','Saceanu','Saftoiu','Sarbu','Scarlat','scurea','Sechelariu','Seciu','selmaru','serb','schiopul','serban','serbanescu','serbanoiu','serbu','serbulescu','Seulescu','Sihleanu','Silas','Simionescu','Simu','sirato','Sireteanu','Sireteanu','Sirghie','Sirma','Skutnik','Slavici','Smochina','Soare','Socolescu','Solacolu','soldea','Soltan','Somesan','Sorescu','Sorohan','Spadaru','Spataru','Spineanu','Spircu','Spirlea','Stamatin','Stamatu','Stan','Stanca','Stancu','Stanculescu','Stavarache','Stanescu','stefanescu','stefanuca','steflea','stefureac','Stelian','stirbei','Stoenescu','Stoian','Stolnici','Strajescu','Stratilescu','Stroe','Stroescu','Stroici','Sturdza','Sturza','Suceveanu','Suciu','Surdu','susman','schiopu','Tabara','Tabaras','Talianu','Tamas','Tapalaga','taranu','Tariceanu','Tatomirescu','Tavitian','Tanase','Teleanu','tenescu','Teodorascu','Teodorescu','Teodosiu','tepeneag','Tescanu','Tighineanu','Timica','Timofte','Timofti','tirle','Tiron','Tismaneanu','titeica','Todea','Toderas','Todiras','Todoran','Toduta','Toma','Tomita','Tomoiaga','Toneanu','Topor','Torje','Trandafir','Trasca','Trifa','Trifan','Trifu','Tudan','Tudor','Tudorache','Tudoran','Tudose','Tuducan','tulea','Turcan','turcan','turcanu','Turcescu','Turcu','Turdeanu','tutea','Tutoveanu','Udila','Udrea','Uglar','Ulmeanu','Ungheanu','Ungur','Ungureanu','Urs','Ursachianu','Urziceanu','Vacaroiu','Vadineanu','Vaduva','Valcu','Valeanu','Valuta','Vanatoru','Vanghelie','Varo','Varzar','Vasescu','Vasilescu','Vasiliu','Vatamanu','Vantu','Vellescu','Vernescu','Vianu','Vicoveanca','Videanu','Vilcu','Vindereu','Vintan','Vioreanu','Vitcu','Vladescu','Vladimirescu','Vladu','Vlahuta','Vlaicu','Vlasiu','Vladarau','Voicu','Voiculescu','Voiculet','Voina','Voinea','Voinescu','Vraca','Vulcan','Vulcanescu','Vulpe','Vulpescu','Xenopol','Zaharescu','Zaharia','Zarnescu','Zavati','Zavoda','Zavoranu','Zbenghea','Zegrean','Zegreanu','Zgondea','Zidaru','Zlotea','Zorlescu','Zotta','Zugravescu');
137 lista_prenume_feminine vector := vector('Ada','Adela','Adelaida','Adelina','Adina','Adriana','Agata','Aglaia','Agripina','Aida','Alberta','Albertina','Alexandra','Alexandrina','Alice','Alida','Alina','Alis','Alma','Amalia','Amanda','Amelia','Ana','Anabela','Anaida','Anamaria','Anastasia','Anca','Ancuta','Anda','Andra','Andrada','Andreea','Anemona','Aneta','Angela','Anghelina','Anica','Anisoara','Antoaneta','Antonela','Antonia','Anuta','Ariadna','Ariana','Arina','Aristita','Artemisa','Astrid','Atena','Augustina','Aura','Aurelia','Aureliana','Aurica','Aurora','Axenia','Beatrice','Betina','Bianca','Blanduzia','Bogdana','Brandusa','Camelia','Carina','Carla','Carmen','Carmina','Carolina','Casandra','Casiana','Caterina','Catinca','Catrina','Catrinel','Catalina','Cecilia','Celia','Cerasela','Cezara','Cipriana','Clara','Clarisa','Claudia','Clementina','Cleopatra','Codrina','Codruta','Constanta','Constantina','Consuela','Coralia','Corina','Cornelia','Cosmina','Crenguta','Crina','Cristina','Daciana','Dafina','Daiana','Dalia','Dana','Daniela','Daria','Dariana','Delia','Demetra','Denisa','Despina','Diana','Dida','Didina','Dimitrina','Dina','Dochia','Doina','Domnica','Dora','Doriana','Dorina','Dorli','Draga','Dumitra','Dumitrana','Ecaterina','Eftimia','Elena','Eleonora','Eliana','Elisabeta','Elisaveta','Eliza','Elodia','Elvira','Emanuela','Emilia','Erica','Estera','Eufrosina','Eugenia','Eusebia','Eva','Evanghelina','Evelina','Fabia','Fabiana','Felicia','Filofteia','Fiona','Flavia','Floare','Floarea','Flora','Florenta','Florentina','Floriana','Florica','Florina','Francesca','Frusina','Gabriela','Geanina','Gentiana','Georgeta','Georgia','Georgiana','Geta','Gherghina','Gianina','Gina','Giorgiana','Gratiana','Gratiela','Henrieta','Heracleea','Hortensia','Iasmina','Ica','Ileana','Ilinca','Ilona','Ina','Ioana','Ioanina','Iolanda','Ionela','Ionelia','Iosefina','Iridenta','Irina','Iris','Isabela','Iulia','Iuliana','Iustina','Ivona','Izabela','Jana','Janeta','Janina','Jasmina','Jeana','Julia','Julieta','Larisa','Laura','Laurentia','Lavinia','Lacramioara','Leana','Lelia','Leontina','Leopoldina','Letitia','Lia','Liana','Lidia','Ligia','Lili','Liliana','Lioara','Livia','Loredana','Lorelei','Lorena','Luana','Lucia','Luciana','Lucretia','Ludmila','Ludovica','Luiza','Luminita','Magdalena','Maia','Malvina','Manuela','Mara','Marcela','Marcheta','Marga','Margareta','Maria','Mariana','Maricica','Marilena','Marina','Marinela','Marioara','Marta','Matilda','Madalina','Malina','Marioara','Mariuca','Melania','Melina','Mihaela','Milena','Minodora','Mioara','Mirabela','Mirela','Mirona','Miruna','Mona','Monalisa','Monica','Nadia','Narcisa','Natalia','Natasa','Nicoleta','Niculina','Nidia','Noemi','Nora','Norica','Oana','Octavia','Octaviana','Ofelia','Olga','Olimpia','Olivia','Ortansa','Otilia','Ozana','Pamela','Paraschiva','Patricia','Paula','Paulica','Paulina','Petronela','Petruta','Pompilia','Profira','Rada','Rafila','Raluca','Ramona','Rebeca','Renata','Rica','Roberta','Robertina','Rodica','Romanita','Romina','Roxana','Roxelana','Roza','Rozalia','Ruxanda','Ruxandra','Sabina','Sabrina','Safta','Salomea','Sanda','Saveta','Savina','Sanziana','Semenica','Severina','Sidonia','Silvana','Silvia','Silviana','Simina','Simona','Smaranda','Sofia','Sonia','Sorana','Sorina','Speranta','Stana','Stanca','Stela','Steliana','Steluta','Suzana','Svetlana','stefana','stefania','Tamara','Tania','Tatiana','Teea','Teodora','Teodosia','Teona','Tiberia','Timea','Tinca','Tincuta','Tudora','Tudorita','Tudosia','Valentina','Valeria','Vanesa','Varvara','Vasilica','Venera','Vera','Veronica','Veta','Vicentia','Victoria','Violeta','Viorela','Viorica','Virginia','Viviana','Vladelina','Voichita','Xenia','Zaharia','Zamfira','Zaraza','Zenobia','Zenovia','Zina','Zoe');
138 lista_prenume_masculine vector := vector('Achim','Adam','Adelin','Adi','Adonis','Adrian','Agnos','Albert','Aleodor','Alex','Alexandru','Alexe','Alin','Alistar','Amedeu','Amza','Anatolie','Andrei','Andrian','Angel','Anghel','Antim','Anton','Antonie','Antoniu','Arian','Aristide','Arsenie','Augustin','Aurel','Aurelian','Aurica','Avram','Axinte','Barbu','Bartolomeu','Basarab','Banel','Bebe','Beniamin','Benone','Bernard','Bogdan','Bradut','Bucur','Caius','Camil','Cantemir','Carol','Casian','Cazimir','Calin','Catalin','Cedrin','Cezar','Ciprian','Claudiu','Codin','Codrin','Codrut','Constantin','Cornel','Corneliu','Corvin','Cosmin','Costache','Costel','Costin','Crin','Cristea','Cristian','Cristobal','Cristofor','Dacian','Damian','Dan','Daniel','Darius','David','Decebal','Denis','Dinu','Dominic','Dorel','Dorian','Dorin','Dorinel','Doru','Dragos','Ducu','Dumitru','Edgar','Edmond','Eduard','Eftimie','Emanoil','Emanuel','Emanuil','Emil','Emilian','Eremia','Eric','Ernest','Eugen','Eusebiu','Eustatiu','Fabian','Felix','Filip','Fiodor','Flaviu','Florea','Florentin','Florian','Florin','Francisc','Gabi','Gabriel','Gelu','George','Georgel','Georgian','Ghenadie','Gheorghe','Gheorghita','Ghita','Gica','Gicu','Giorgian','Gratian','Gregorian','Grigore','Haralamb','Haralambie','Horatiu','Horea','Horia','Iacob','Iancu','Ianis','Ieremia','Ilarie','Ilarion','Ilie','Inocentiu','Ioan','Ion','Ionel','Ionica','Ionut','Iosif','Irinel','Iulian','Iuliu','Iurie','Iustin','Iustinian','Ivan','Jan','Jean','Jenel','Ladislau','Lascar','Laurentiu','Laurian','Lazar','Leonard','Leontin','Leordean','Lica','Liviu','Lorin','Luca','Lucentiu','Lucian','Lucretiu','Ludovic','Manole','Marcel','Marcu','Marian','Marin','Marius','Martin','Matei','Maxim','Maximilian','Madalin','Mihai','Mihail','Mihnea','Mina','Mircea','Miron','Mitica','Mitrut','Mugur','Mugurel','Nae','Narcis','Nechifor','Nelu','Nichifor','Nicoara','Nicodim','Nicolae','Nicolaie','Nicu','Niculita','Nicusor','Nicuta','Norbert','Norman','Octav','Octavian','Octaviu','Olimpian','Olimpiu','Oliviu','Ovidiu','Pamfil','Panagachie','Panait','Paul','Pavel','Patru','Petre','Petrica','Petrisor','Petru','Petrut','Plesu','Pompiliu','Radu','Rafael','Rares','Raul','Raducu','Razvan','Relu','Remus','Robert','Romeo','Romulus','Sabin','Sandu','Sandu','Sava','Sebastian','Sergiu','Sever','Severin','Silvian','Silviu','Simi','Simion','Sinica','Sorin','Stan','Stancu','Stelian','serban','stefan','Teodor','Teofil','Teohari','Theodor','Tiberiu','Timotei','Titus','Todor','Toma','Traian','Tudor','Valentin','Valeriu','Valter','Vasile','Vasilica','Veniamin','Vicentiu','Victor','Vincentiu','Viorel','Visarion','Vlad','Vladimir','Vlaicu','Voicu','Zamfir','Zeno');
139 lista_strazi vector := vector('Alee Alecsandri Vasile','Alee Alexa Gheorghe, prof. dr. ing.','Alee Atanasiu Dimitrie, prof. dr. ing.','Alee Basarabi','Alee Basota','Alee Bucium','Alee Canta','Alee Cimitirul Evreiesc','Alee Columnei','Alee Copou','Alee Decebal','Alee Dumbrava Rosie','Alee Ghica Grigore Voda','Alee Gradinari','Alee Micle Veronica','Alee Mircea cel Batran','Alee Musatini','Alee Neculai Tudor','Alee Nicolina','Alee Oltea Doamna','Alee Pacurari','Alee Parcului','Alee Petrescu Vasile, prof. dr. doc.','Alee Plaiesilor','Alee Plopii fara Sot','Alee Poni Petru','Alee Procopiu Stefan','Alee Rozelor','Alee Sadoveanu Mihail','Alee Simionescu I. I.','Alee Spital Pascanu','Alee Strugurilor','Alee Sucidava','Alee Trandafirilor','Alee Uzinei','Alee Vitejilor','Bulevard Alexandru cel Bun','Bulevard Carol I','Bulevard Chimiei','Bulevard Dacia','Bulevard Dimitrie Cantemir','Bulevard Independentei','Bulevard Iorga Nicolae','Bulevard Mangeron Dimitrie, prof. dr. doc.','Bulevard Metalurgiei','Bulevard Poitiers','Bulevard Primaverii','Bulevard Rosetti C. A.','Bulevard Socola','Bulevard Stefan cel Mare si Sfant','Bulevard Tutora','Bulevard Vladimirescu Tudor','Cale Chisinaului','Cale Galata','Fundac 40 Sfinti','Fundac Armeana','Fundac Aurora','Fundac Balusescu','Fundac Boiangiu','Fundac Bucium','Fundac Bucovinei','Fundac Calarasi','Fundac Caramidari','Fundac Catargi Lascar','Fundac Cocoarei','Fundac Codrescu Teodor','Fundac Dancinescu','Fundac Delfini','Fundac Dochia','Fundac Dragos Voda','Fundac Elena Doamna','Fundac Eternitate','Fundac Ferentz','Fundac Florentz','Fundac Gandu','Fundac Ispirescu Petre','Fundac Kogalniceanu Mihail','Fundac Maracineanu Valter','Fundac Mielului','Fundac Mircea','Fundac Mitocul Maicilor','Fundac Moara de Vant','Fundac Muntenimii','Fundac Muzicescu Gavril','Fundac Olari','Fundac Paun','Fundac Perjoaia','Fundac Pietrariei','Fundac Plopii fara Sot','Fundac Pralea','Fundac Racovita Emil','Fundac Ralet Dimitrie','Fundac Salciilor','Fundac Sararie','Fundac Sf. Andrei','Fundac Sf. Teodor','Fundac Sf. Vasile','Fundac Sipotel','Fundac Socola','Fundac Strugurilor','Fundac Tanasescu','Fundac Tanjala','Fundac Trei Ierarhi','Fundac Ursulea','Fundac Vantu','Fundac Zaverei','Fundac Zlataust','Pasaj Cuza Voda','Pasaj Muzicescu Gavril','Piata 14 Decembrie 1989','Piata Eminescu Mihai','Piata Garii','Piata Halei','Piata Natiunii','Piata Stefan cel Mare si Sfant','Piata Unirii','Piata Voievozilor','Platou Abator','Sosea Albinet','Sosea Arcu','Sosea Barnova','Sosea Bucium','Sosea Carlig','Sosea Galata','Sosea Iasi-Ciurea','Sosea Iasi-Tomesti','Sosea Manta Rosie','Sosea Moara de Foc','Sosea Nationala','Sosea Neculai Tudor','Sosea Nicolina','Sosea Pacurari','Sosea Rediu','Sosea Sararie','Sosea Stefan cel Mare si Sfant','Sosea Voinesti','Splai Bahlui Mal Drept','Splai Bahlui Mal Stang','Strada 14 Decembrie 1989','Strada Abrahamfi','Strada Adunati','Strada Aeroportului','Strada Agricultori','Strada Alba','Strada Alba Iulia','Strada Albinelor','Strada Albinet','Strada Alecsandri Vasile','Strada Alexandrescu Emil','Strada Alexandru Lapusneanu','Strada Alistar','Strada Alunis','Strada Amurgului','Strada Andrei Petre','Strada Apelor','Strada Arapului','Strada Arbore Luca','Strada Arcu','Strada Arges','Strada Armeana','Strada Armoniei','Strada Aroneanu','Strada Asachi Gheorghe','Strada Atelierului','Strada Ateneului','Strada Aterizaj','Strada Aurora','Strada Aviatiei','Strada Avionului','Strada Azilului','Strada Babes Victor','Strada Bacalu Iancu','Strada Bacinschi','Strada Balcescu Nicolae','Strada Baltii','Strada Balusescu','Strada Banat','Strada Bancii','Strada Bancila Octav, pictor','Strada Banu','Strada Barboi','Strada Barbu Lautaru','Strada Bariera Veche','Strada Barnovschi','Strada Barnutiu Simion','Strada Barsescu Agatha','Strada Bas Ceaus','Strada Basarabi','Strada Basota','Strada Beldiceanu Nicolae','Strada Belvedere','Strada Berindei Ioan, arh.','Strada Berthelot, g-ral','Strada Bistrita','Strada Bogdan Voda','Strada Boiangiu','Strada Borcea','Strada Botez Octav','Strada Bradetului','Strada Bradului','Strada Brandusa','Strada Brates','Strada Bratianu I.C.','Strada Bratului','Strada Breazu','Strada Brudea','Strada Bucium','Strada Bucovinei','Strada Bucur','Strada Bujor Paul','Strada Bularga','Strada Buna Vestire','Strada Burada Teodor','Strada Buridava','Strada Busuioc','Strada Butnari','Strada Buzescu','Strada Buznea','Strada Calafat','Strada Calarasi','Strada Calugareni','Strada Canta','Strada Cantacuzino Dumitrascu','Strada Cantacuzino G.M., arh.','Strada Caprelor','Strada Capsunilor','Strada Caragiale I. L.','Strada Caraiman','Strada Caraman Petru','Strada Caramidari','Strada Caranda, lt.','Strada Carlig','Strada Carpati','Strada Casin','Strada Catargi Lascar','Strada Cazangiilor','Strada Cazarmilor','Strada Cazimir Otilia','Strada Ceahlau','Strada Cerchez','Strada Cerna','Strada Cetatuia','Strada Cicoarei','Strada Cihac Iosif','Strada Ciornei','Strada Ciresica','Strada Ciric','Strada Cismeaua lui Butuc','Strada Ciurchi','Strada Ciusmeaua Pacurari','Strada Clopotari','Strada Codrescu Teodor','Strada Columnei','Strada Cometa','Strada Conductelor','Strada Conta Vasile','Strada Cosbuc George','Strada Costachescu Mihai','Strada Costin Nicolae','Strada Cozma Toma','Strada Creanga Ion','Strada Crihan Anton','Strada Cristofor','Strada Crisului','Strada Crivat','Strada Cucu','Strada Cujba Petru, prof.','Strada Cupidon','Strada Curelari','Strada Cuza Voda','Strada Dacia','Strada Dancinescu','Strada Dancu','Strada De Nord','Strada Dealul Bucium','Strada Dealul Galata','Strada Dealul Zorilor','Strada Decebal','Strada Delavrancea Barbu Stefanescu','Strada Delfini','Strada Deliu','Strada Dezrobirii','Strada Dimitrescu Toma, g-ral','Strada Dochia','Strada Doja Gheorghe','Strada Donos','Strada Dorobanti','Strada Dorojinca','Strada Draghici Manolache','Strada Dragos Voda','Strada Drobeta','Strada Duca Voda','Strada Dudescu','Strada Dumbrava Rosie','Strada Egalitatii','Strada Elena Doamna','Strada Eminescu Mihai','Strada Enescu George','Strada Eternitate','Strada Fagetului','Strada Fagului','Strada Fantanilor','Strada Fatu Anastasie','Strada Fericirii','Strada Fierbinte','Strada Flammarion Camile','Strada Florea','Strada Florilor','Strada Fluturilor','Strada Folescu Marchian','Strada Fragilor','Strada Franta','Strada Fratilor','Strada Friederick','Strada Frumoasa','Strada Frunzei','Strada Fulger','Strada Functionarilor','Strada Galateanu','Strada Galbeni','Strada Gandu','Strada Gane Nicolae','Strada Garii','Strada Ghibanescu Gheorghe','Strada Ghica Grigore Voda','Strada Ghioceilor','Strada Gloriei','Strada Golia','Strada Gospodari','Strada Grabovenschi','Strada Gradinari','Strada Graniceri','Strada Greerul','Strada Halipa Pantelimon','Strada Han Tatar','Strada Hanciuc','Strada Hasdeu B. Petriceicu','Strada Heliade','Strada Hlincea','Strada Holboca','Strada Horga','Strada Horia','Strada Hotin','Strada Iarmaroc','Strada Ibraileanu Garabet','Strada Icoanei','Strada Iepurilor','Strada Iernii','Strada Ignat','Strada Imas','Strada Inculet Ion, prof.','Strada Ion Grigore, serg.','Strada Ion Paul, prof.','Strada Ionescu, lt.','Strada Iosif Stefan Octavian','Strada Ipsilanti Alexandru Voda','Strada Islaz','Strada Ispirescu Petre','Strada Istrati N.','Strada Italiana','Strada Izbandei','Strada Izvor','Strada Jelea','Strada Kogalniceanu Mihail','Strada Lacului','Strada Langa, col.','Strada Lascar Gheorghe','Strada Leon N., dr.','Strada Libertatii','Strada Lotrului','Strada Luminei','Strada Lupitei','Strada Luterana','Strada Macarescu Nicolae','Strada Macazului','Strada Macedoniei','Strada Magurei','Strada Mahu','Strada Maiorescu Titu','Strada Malu','Strada Manastirii','Strada Manolescu','Strada Manta Rosie','Strada Maracineanu Valter','Strada Marasesti','Strada Marasti','Strada Marginei','Strada Marta','Strada Masinii','Strada Mayer Octav','Strada Meteor','Strada Micsunelelor','Strada Mihai Radu','Strada Mihai Voda Viteazul','Strada Milcov','Strada Millo Matei','Strada Minervei','Strada Mioritei','Strada Mircea cel Batran','Strada Miron Costin','Strada Mironescu I. I.','Strada Miroslava','Strada Misai','Strada Mistretului','Strada Mitropoliei','Strada Mitropolit Veniamin Costache','Strada Mizil','Strada Moara de Vant','Strada Mocanului','Strada Moldovei','Strada Morilor','Strada Mosu','Strada Motilor','Strada Movila Pacureti','Strada Movilei','Strada Munteni','Strada Muntenimii','Strada Musatini','Strada Mustea, cronicar','Strada Muzicescu Gavril','Strada Muzicii','Strada Namoloasa','Strada Naniescu Iosif, mitropolit','Strada Neculau','Strada Neculce Ion','Strada Negel Gheorghe, lt.','Strada Negri Costache','Strada Negustori','Strada Neptun','Strada Niceman','Strada Nicolina','Strada Nicorita','Strada Nisipari','Strada Noua','Strada Oancea','Strada Oastei','Strada Obreja','Strada Occident','Strada Ogorului','Strada Oituz','Strada Olari','Strada Olt','Strada Olteniei','Strada Orfelinatului','Strada Orientului','Strada Ornescu','Strada Otelari','Strada Ovidiu','Strada Pacii','Strada Pacurari','Strada Pacureti','Strada Padurii','Strada Palat','Strada Pallady Theodor','Strada Pantel','Strada Pantelimon','Strada Panu Anastasie','Strada Parcului','Strada Pastorului','Strada Patria','Strada Paulescu, dr.','Strada Paun','Strada Pavlov I. P.','Strada Penes Curcanul','Strada Perju','Strada Petru Rares','Strada Petru Schiopu','Strada Philippide, prof.','Strada Pictorului','Strada Pietrariei','Strada Pinului','Strada Plaiesilor','Strada Plantelor','Strada Plevnei','Strada Plopii fara Sot','Strada Podgoriilor','Strada Podisului','Strada Podoleanu','Strada Podu de Piatra','Strada Podul Inalt','Strada Poetului','Strada Pogor Vasile','Strada Poienilor','Strada Pojarniciei','Strada Poligon','Strada Pompei','Strada Pompieri','Strada Poni Petru','Strada Ponoarelor','Strada Popauti','Strada Popescu Eremia, mr.','Strada Popovici, lt.','Strada Porumbului','Strada Potcoavei','Strada Protopopescu, cpt.','Strada Rachiti','Strada Racovita Emil','Strada Radu Voda','Strada Rafael','Strada Ralet Dimitrie','Strada Ramadan Constantin','Strada Rampei','Strada Randunica','Strada Rapa Galbena','Strada Rapei','Strada Rascanu Teodor','Strada Razboieni','Strada Razoarelor','Strada Rece','Strada Rediu','Strada Roadelor','Strada Roata Ion','Strada Rojnita','Strada Roman Voda','Strada Romana','Strada Roscani','Strada Rosiori','Strada Rovine','Strada Rufeni','Strada Russo Alecu','Strada Sadoveanu Mihail','Strada Salciilor','Strada Sambetei','Strada Sapte Oameni','Strada Sararie','Strada Sarmisegetuza','Strada Saulescu Gheorghe','Strada Savescu Toma','Strada Savini, Dr.','Strada Scaricica','Strada Scoalei','Strada Semanatorului','Strada Semnului','Strada Sendrea, Hatman','Strada Sesan A., prof.','Strada Sevastopol','Strada Sf. Andrei','Strada Sf. Atanasiei','Strada Sf. Constantin','Strada Sf. Gheorghe','Strada Sf. Ioan','Strada Sf. Lazar','Strada Sf. Sava','Strada Sf. Teodor','Strada Sf. Vasile','Strada Silvestru','Strada Simionescu I. I.','Strada Sipotel','Strada Smardan','Strada Soarelui','Strada Soficu','Strada Sorogari','Strada Spancioc','Strada Spinti','Strada Spital Pascanu','Strada Stanciu','Strada Stejar','Strada Stere Constantin, prof.','Strada Stihii','Strada Stindardului','Strada Stoicescu, lt.','Strada Stramosilor','Strada Strapungere Silvestru','Strada Stroescu Vasile','Strada Stroici','Strada Strugurilor','Strada Sturdza Mihai','Strada Sucidava','Strada Sulfinei','Strada Tabacului','Strada Tacuta','Strada Tafrali Orest, prof.','Strada Taietoarei','Strada Talpalari','Strada Tanasescu','Strada Tatarasi','Strada Teodoreanu Al. O.','Strada Teodoreanu Ionel','Strada Tepes Voda','Strada Ticaul de Jos','Strada Timpului','Strada Toamnei','Strada Tomida, cpt.','Strada Toparceanu George','Strada Traian','Strada Transilvaniei','Strada Trantomir','Strada Trei Fantani','Strada Trei Ierarhi','Strada Trofeelor','Strada Trompeta','Strada Tufescu','Strada Turcu','Strada Tutea Petre','Strada Ungheni','Strada Universitatii','Strada Urcusului','Strada Ureche Grigore','Strada Urechia Vasile','Strada Ursulea','Strada Uzinei','Strada Valea Adanca','Strada Valeni','Strada Vamasoaia','Strada Vanatori','Strada Vantu','Strada Varlaam, Mitropolit','Strada Vascauteanu','Strada Vasile Lupu','Strada Venerei','Strada Veniamin Costache','Strada Verdes','Strada Vicol N., dr.','Strada Viespei','Strada Viitor','Strada Virgiliu','Strada Visan','Strada Vitejilor','Strada Viticultori','Strada Vladiceni','Strada Vladimirescu Tudor','Strada Vlahuta Alexandru','Strada Vlaicu Aurel','Strada Voinicilor','Strada Vovideniei','Strada Vulpe','Strada Vulturilor','Strada Xenopol A.','Strada Zarafi','Strada Zborului','Strada Zidari','Strada Zimbrului','Strada Zlataust','Strada Zmeu','Strada Zorilor','Strada Zugravi','Stradela Adunati','Stradela Armeana','Stradela Baltii','Stradela Barboi','Stradela Barbu Lautaru','Stradela Berindei Ioan, arh.','Stradela Bucsinescu','Stradela Canta','Stradela Caprelor','Stradela Caramidari','Stradela Cazangiilor','Stradela Cetatuia','Stradela Cicoarei','Stradela Ciric','Stradela Clopotari','Stradela Copou','Stradela Dealul Bucium','Stradela Elena Doamna','Stradela Florilor','Stradela Galateanu','Stradela Gradinari','Stradela Harhas','Stradela Inculet Ion, prof.','Stradela Ionescu de la Brad Ion','Stradela Iosif Stefan Octavian','Stradela Ipsilanti Alexandru Voda','Stradela Italiana','Stradela Langa, col.','Stradela Luminei','Stradela Macazului','Stradela Manta Rosie','Stradela Mironescu I. I.','Stradela Mizil','Stradela Moara de Vant','Stradela Nicorita','Stradela Pacureti','Stradela Paun','Stradela Perju','Stradela Plopii fara Sot','Stradela Poienilor','Stradela Primaverii','Stradela Rediu','Stradela Sararie','Stradela Savescu Toma','Stradela Scaricica','Stradela Sf. Andrei','Stradela Sf. Atanasiei','Stradela Sf. Constantin','Stradela Sf. Gheorghe','Stradela Sf. Stefan','Stradela Silvestru','Stradela Spinti','Stradela Stefan cel Mare si Sfant','Stradela Trei Ierarhi','Stradela Uzinei','Stradela Vantu','Stradela Vladimirescu Tudor','Trecere Alpilor','Trecere Bravilor','Trecere Bucsinescu','Trecere Cazimir Otilia','Trecere Ciobanului','Trecere Corbului','Trecere Davidel','Trecere Doamnei','Trecere Duzilor','Trecere Fantanilor','Trecere Hotin','Trecere Leului','Trecere Mincu Ion, arh.','Trecere Nucului','Trecere Oitelor','Trecere Paun','Trecere Podgoriilor','Trecere Pricop','Trecere Transeului','Trecere Trei Ierarhi','Trecere Visan','Varianta Uzinei');
140 lista_meniu vector := vector('PIZZA','CALZONI','PASTE','GRILL','PREPARATE LA CUPTOR','CIORBE','TAGLIERI','SALATE','GARNITURI','SALATE GARNITURI','DESERT','RACORITOARE');
141 lista_mancare vector := vector('Pizza Peppei e Salsiccia','Pizza Tonno e Cipolla','Pizza Salame piccante','Pizza Quattro Formaggi','Pizza Vegetariana','Pizza cu creveti','Pizza Mantova','Pizza Parma','Pizza Trento','Pizza Modena','Pizza Milano','Pizza Sorrento','Pizza Margherita','Pizza Bufalissima','Pizza Quattro Stagioni','Pizza Quattro Salumi','Pizza Doppio Zero','Pizza Capriciosa','Pizza Sante','Pizza Diavola','Pizza Romana','Pizza Prosciutto Cotto','Pizza Pollo e Funghi','Pizza Prosciutto e Funghi','Pizza Kids','Pizza Iasi','Calzoni Classico','Calzoni Saporito','Penne Ragu','Spaghetti Carbonara','Spaghetti Amatriciana','Fusilli Tonno','Tagliatele Vegetariene','Penne Pomodoro','Spaghetti Aglio Olio Pepecino','Paste cu creveti','Cotlet','Ceafa','Piept de pui','Antricot de vita','Cotlet Haiducesc','Pui Vienez','Pui la cuptor','Pui Doppio Zero','Ciorba de pui','Ciorba de vacuta','Ciorba radauteana','Ciorba de burta','Turta de casa','Turta de casa','Taglieri all-italiana','Caprese','Salata Romagna','Salata Lazio','Salata Veneto','Salata Trentino','Salata Lombardia','Salata Puglia','Salata Sicilia','Legume la gratar','Cartofi prajiti','Cartofi taranesti','Risotto cu parmezan','Conopida trasa la tigaie','Cartofi wedges','Salata mixta','Ardei copti','Castraveti si gogonele in otet','Salata de varza','Clatite cu ciocolata','Marchiza','Maringata','Fistic Cake','Saveur de melon','Biscomilk','Clatite la cuptor','Clatite cu dulceata','Coca Cola 250 ml','Fanta orange 250 ml','Fanta lemon 250 ml','Fanta madness 250 ml','Sprite 250 ml','Schweppes kinley tonic 250 ml','Schweppes lemon 250 ml','Schweppes mandarin 250 ml','Cappy orange 250 ml','Cappy peach 250 ml','Cappy pear 250 ml','Cappy red orange 250 ml','Cappy sou cherry 250 ml','Apa plata 330 ml','Apa minerala 330 ml');
142 lista_preturi vector := vector('29,50','31,50','28,50','31,50','28,50','41,00','29,50','40,50','32,50','31,50','29,50','38,50','22,50','38,50','31,50','32,50','39,50','32,50','39,50','32,50','29,50','28,50','29,50','29,50','31,50','31,50','27,50','30,50','25,50','26,50','26,50','29,50','22,50','20,50','22,50','34,00','22,50','22,50','21,50','26,50','32,00','32,00','37,00','32,00','12,00','12,00','12,00','14,00','2,00','4,00','60,00','40,00','21,00','21,00','23,00','24,00','23,00','26,00','22,00','7,00','6,50','6,50','8,00','8,00','7,50','7,00','9,00','7,00','5,00','9,00','13,00','13,00','13,00','13,00','13,00','14,00','9,00','5,00','5,00','5,00','5,00','5,00','5,00','5,00','5,00','6,00','6,00','6,00','6,00','6,00','5,00','5,00');
143 lista_produse vector := vector('suc de rosii','mozzarella','ardei gras','ardei','carnat de porc','ton','ceapa','salam iute','gorgonzola','emmental','grana','vinete','dovlecel','rosii mici','creveti','rosii cherry','rosii','ulei cu usturoi','usturoi','mozzarella di bufala','prosciutto crudo','rucola','ciuperci','spek','slanina slaba','ananas','sunca','busuioc','masline','salam dulce','salam picant','bacon','oregano','suc de rosii semipicant','salsiccia','ansoa','capere','pui','porumb','sos de rosii','piept de pui','mozzarela','carne de porc si vitel','legume','ou','pecorino','gran cucina','dovlecei','ulei de masline','pepecino','patrunjel','cotlet','ceafa','antricot de vita','vita','cotlet de porc','sos tomate','cartofi','smantana grasa','smantana','unt','sos tzatziki','mamaliga','gogosari la otet','sos tailandez','risotto','parmezan','faina','oua','mezeluri mixte','branzeturi mixte cu fornarino','salata','masline negre','ansoa marinate','paine prajita','crema de branza topita','ou fiert','porumb fiert','nuci','otet balsamic','branza feta','castraveti','conopida','gogonele','varza','lapte','esenta','apa minerala','crema de ciocolata','zahar','faina de grau','cacao','frisca','mascarpone','glazura de ciocolata','migdale','alune de padure','ciocolata alba','ciocolata','crema de fistic','arahide','pandispan','crema pepene','maca','biscuiti de ovaz','crema de lapte','biscuiti oreo','pandispan cacao','branza de vaci','stafide','dulceata','pere','coca cola','fanta orange','fanta lemon','fanta madness','sprite','schweppes kinley tonic','schweppes lemon','schweppes mandarin','cappy orange','cappy peach','cappy pear','cappy red orange','cappy sou cherry','apa plata');
144 lista_mancare_ingrediente vector := vector('suc de rosii','mozzarella','ardei gras','carnat de porc','suc de rosii','mozzarella','ton','ceapa','suc de rosii','mozzarella','salam iute','suc de rosii','mozzarella','gorgonzola','emmental','grana','suc de rosii','mozzarella','vinete','dovlecel','rosii mici','creveti','rosii cherry','ulei cu usturoi','mozzarella','grana','suc de rosii','mozzarella','salam iute','gorgonzola','suc de rosii','mozzarella','mozzarella di bufala','prosciutto crudo','rucola','rosii cherry','mozzarella','ciuperci','gorgonzola','spek','suc de rosii','mozzarella','carnat de porc','slanina slaba','suc de rosii','mozzarella','ananas','sunca','suc de rosii','mozzarella','mozzarella di bufala','prosciutto crudo','suc de rosii','mozzarella','suc de rosii','mozzarella di bufala','rosii cherry','busuioc','suc de rosii','mozzarella','ciuperci','sunca','ardei gras','masline','suc de rosii','mozzarella','sunca','salam dulce','salam picant','suc de rosii','sunca','salam dulce','bacon','ardei gras','ciuperci','ceapa','oregano','suc de rosii','mozzarella','ciuperci','sunca','ardei gras','masline','carnat de porc','suc de rosii semipicant','mozzarella di bufala','salam picant','busuioc','suc de rosii','mozzarella','salam picant','salsiccia','ardei gras','suc de rosii','mozzarella','ansoa','oregano','capere','suc de rosii','mozzarella','sunca','suc de rosii','mozzarella','pui','ciuperci','suc de rosii','mozzarella','ciuperci','sunca','salam dulce','porumb','sos de rosii','mozzarella','piept de pui','suc de rosii','mozzarella','porumb','bacon','suc de rosii','mozzarella','sunca','ciuperci','suc de rosii','mozzarela','salam iute','ardei gras','gorgonzola','carne de porc si vitel','legume','sos de rosii','slanina slaba','ou','pecorino','gran cucina','ceapa','slanina slaba','sos de rosii','ton','sos de rosii','vinete','dovlecei','ceapa','ciuperci','sos de rosii','sos de rosii','usturoi','rosii cherry','ulei de masline','pepecino','patrunjel','rosii cherry','usturoi','gran cucina','cotlet','ceafa','piept de pui','antricot de vita','cotlet de porc','ceapa','ardei gras','sos tomate','cartofi','mozzarella','piept de pui','cartofi','smantana grasa','mozzarella','unt','gran cucina','pui','sos tzatziki','mamaliga','cartofi','gogosari la otet','piept de pui','sos tailandez','unt','risotto','parmezan','gran cucina','pui','vita','pui','vita','faina','oua','faina','oua','mezeluri mixte','branzeturi mixte cu fornarino','mozzarella di bufala','rosii cherry','busuioc','salata','mozzarella','masline negre','rosii cherry','ansoa marinate','salata','pui','grana','paine prajita','crema de branza topita','salata','rosii cherry','ou fiert','ton','masline negre','porumb fiert','salata','ciuperci','grana','ardei gras','rosii cherry','salata','gorgonzola','pere','nuci','otet balsamic','salata','mozzarella','rosii cherry','ton','masline negre','porumb fiert','ou fiert','salata','branza feta','castraveti','ceapa','rosii','masline negre','ardei','vinete','dovlecei','ciuperci','cartofi','cartofi','risotto','parmezan','conopida','cartofi','rosii','castraveti','ardei gras','ceapa','ardei','castraveti','gogonele','varza','ou','lapte','esenta','faina','apa minerala','crema de ciocolata','ciocolata','oua','zahar','faina de grau','cacao','frisca','zahar','oua','mascarpone','glazura de ciocolata','migdale','unt','alune de padure','ciocolata alba','frisca','crema de fistic','arahide','pandispan','oua','crema pepene','zahar','maca','biscuiti de ovaz','frisca','crema de lapte','biscuiti oreo','glazura de ciocolata','pandispan cacao','ou','lapte','esenta','apa minerala','branza de vaci','stafide','smantana','ou','lapte','esenta','faina','apa minerala','dulceata','coca cola','fanta orange','fanta lemon','fanta madness','sprite','schweppes kinley tonic','schweppes lemon','schweppes mandarin','cappy orange','cappy peach','cappy pear','cappy red orange','cappy sou cherry','apa plata','apa minerala');
145 lista_mancare_nr_ingrediente vector := vector('4','4','3','5','5','5','4','6','4','4','4','4','2','4','6','5','8','7','4','5','5','3','4','4','4','5','4','5','3','4','3','2','5','1','5','3','1','1','1','1','6','6','5','6','1','1','1','1','2','2','2','3','5','5','6','5','5','7','6','4','1','1','2','1','1','4','1','2','1','6','5','8','5','5','5','7','6','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1');
146
147
148 p_nume varchar2(256);
149 p_prenume varchar2(256);
150 p_email varchar2(50);
151 p_telefon varchar2(10);
152 p_strada varchar2(50);
153 p_numar_strada number(3);
154 p_temp1 int;
155 p_temp2 int;
156 p_data_comanda date;
157 p_status_comanda varchar2(20);
158 p_cantitate int;
159 p_status_angajat varchar2(15);
160 p_timp_plecare date;
161 p_timp_sosire date;
162 p_suma int;
163 p_tip_plata varchar2(5);
164 p_data_plata date;
165 p_temp3 number(7);
166
167begin
168
169 --Tabela Client
170 dbms_output.put_line('Inserare 10000 clienti.');
171 for p_i in 1..10000
172 loop
173 --Nume
174 p_nume := lista_nume(trunc(dbms_random.value(0,lista_nume.count))+1);
175
176 --Prenume
177 if(trunc(dbms_random.value(0,2))=0) then
178 p_prenume := lista_prenume_feminine(trunc(dbms_random.value(0,lista_prenume_feminine.count))+1);
179 else
180 p_prenume := lista_prenume_masculine(trunc(dbms_random.value(0,lista_prenume_masculine.count))+1);
181 end if;
182
183 p_temp1 := 0;
184 select count(*) into p_temp1 from Client where nume=p_nume and prenume=p_prenume;
185 while(p_temp1 != 0)
186 loop
187 if(trunc(dbms_random.value(0,2))=0) then
188 p_prenume := lista_prenume_feminine(trunc(dbms_random.value(0,lista_prenume_feminine.count))+1);
189 else
190 p_prenume := lista_prenume_masculine(trunc(dbms_random.value(0,lista_prenume_masculine.count))+1);
191 end if;
192 select count(*) into p_temp1 from Client where nume=p_nume and prenume=p_prenume;
193 end loop;
194
195 --Email
196 p_email := lower(p_prenume || '.' || p_nume);
197 p_temp2 := 0;
198 select count(*) into p_temp2 from Client where email=p_email;
199 if(p_temp2 != 0) then
200 p_email := p_email || p_temp2;
201 end if;
202
203 if(trunc(dbms_random.value(0,2))=0) then
204 p_email := p_email || '@gmail.com';
205 else
206 p_email := p_email || '@yahoo.com';
207 end if;
208
209 --Telefon
210 p_telefon := '07';
211 for i in 3..10
212 loop
213 p_telefon := p_telefon || trunc(dbms_random.value(0,10));
214 end loop;
215
216 --Strada
217 p_strada := lista_strazi(trunc(dbms_random.value(0,lista_strazi.count))+1);
218
219 --NumarStrada
220 p_numar_strada := trunc(dbms_random.value(0,200));
221
222 insert into Client values(p_i, p_nume, p_prenume, p_email, p_telefon, p_strada, p_numar_strada, sysdate, sysdate);
223
224 end loop;
225 dbms_output.put_line('S-au inserat 10000 clienti.');
226
227 --Tabela Meniu
228 dbms_output.put_line('Inserare meniu.');
229 for p_i in 1..lista_meniu.count
230 loop
231 insert into Meniu values(p_i, lista_meniu(p_i), sysdate, sysdate);
232 end loop;
233 dbms_output.put_line('S-a inserat meniul.');
234
235 --Tabela Mancare
236 dbms_output.put_line('Inserare mancare.');
237 for p_i in 1..lista_mancare.count
238 loop
239 if(p_i <= 26) then insert into Mancare values(p_i, lista_mancare(p_i), lista_preturi(p_i), 1, sysdate, sysdate); end if;
240 if(26 < p_i and p_i <= 28) then insert into Mancare values(p_i, lista_mancare(p_i), lista_preturi(p_i), 2, sysdate, sysdate); end if;
241 if(28 < p_i and p_i <= 36) then insert into Mancare values(p_i, lista_mancare(p_i), lista_preturi(p_i), 3, sysdate, sysdate); end if;
242 if(36 < p_i and p_i <= 40) then insert into Mancare values(p_i, lista_mancare(p_i), lista_preturi(p_i), 4, sysdate, sysdate); end if;
243 if(40 < p_i and p_i <= 44) then insert into Mancare values(p_i, lista_mancare(p_i), lista_preturi(p_i), 5, sysdate, sysdate); end if;
244 if(44 < p_i and p_i <= 50) then insert into Mancare values(p_i, lista_mancare(p_i), lista_preturi(p_i), 6, sysdate, sysdate); end if;
245 if(50 < p_i and p_i <= 52) then insert into Mancare values(p_i, lista_mancare(p_i), lista_preturi(p_i), 7, sysdate, sysdate); end if;
246 if(52 < p_i and p_i <= 59) then insert into Mancare values(p_i, lista_mancare(p_i), lista_preturi(p_i), 8, sysdate, sysdate); end if;
247 if(59 < p_i and p_i <= 65) then insert into Mancare values(p_i, lista_mancare(p_i), lista_preturi(p_i), 9, sysdate, sysdate); end if;
248 if(65 < p_i and p_i <= 69) then insert into Mancare values(p_i, lista_mancare(p_i), lista_preturi(p_i), 10, sysdate, sysdate); end if;
249 if(69 < p_i and p_i <= 77) then insert into Mancare values(p_i, lista_mancare(p_i), lista_preturi(p_i), 11, sysdate, sysdate); end if;
250 if(77 < p_i and p_i <= 92) then insert into Mancare values(p_i, lista_mancare(p_i), lista_preturi(p_i), 12, sysdate, sysdate); end if;
251 end loop;
252 dbms_output.put_line('S-a inserat mancarea.');
253
254 --Tabela Stoc
255 dbms_output.put_line('Inserare stoc produse.');
256 p_cantitate := 0;
257 for p_i in 1..lista_produse.count
258 loop
259 p_cantitate := trunc(dbms_random.value(0,101));
260 insert into Stoc values(p_i, lista_produse(p_i), p_cantitate, sysdate, sysdate);
261 end loop;
262 dbms_output.put_line('S-a inserat stoc produse.');
263
264 --Tabela Comanda
265 dbms_output.put_line('Inserare 1000000 comenzi.');
266 p_cantitate := 0;
267 for p_i in 1..1000000
268 loop
269 --Data Comanda si Status Comanda
270 if(dbms_random.value(0,100) <= 99) then
271 p_data_comanda := sysdate - trunc(dbms_random.value(0,3000)) + 1;
272 p_status_comanda := 'Livrata';
273 else
274 p_data_comanda := sysdate;
275 p_status_comanda := 'In curs de livrare';
276 end if;
277
278 --Cantitate
279 p_cantitate := trunc(dbms_random.value(0,5)) + 1;
280
281 --Id client si id mancare
282 select count(IDClient) into p_temp1 from Client;
283 select count(IDMancare) into p_temp2 from Mancare;
284
285 insert into Comanda values(p_i, p_data_comanda, p_status_comanda, p_cantitate, trunc(dbms_random.value(0,p_temp1))+1, trunc(dbms_random.value(0,p_temp2))+1, p_data_comanda, sysdate);
286 end loop;
287 dbms_output.put_line('S-au inserat 1000000 comenzi.');
288
289 --Tabela Angajat
290 dbms_output.put_line('Inserare 50 angajati.');
291 for p_i in 1..50
292 loop
293 --Nume
294 p_nume := lista_nume(trunc(dbms_random.value(0,lista_nume.count))+1);
295
296 --Prenume
297 if(trunc(dbms_random.value(0,2))=0) then
298 p_prenume := lista_prenume_feminine(trunc(dbms_random.value(0,lista_prenume_feminine.count))+1);
299 else
300 p_prenume := lista_prenume_masculine(trunc(dbms_random.value(0,lista_prenume_masculine.count))+1);
301 end if;
302
303 p_temp1 := 0;
304 select count(*) into p_temp1 from Angajat where nume=p_nume and prenume=p_prenume;
305 while(p_temp1 != 0)
306 loop
307 if(trunc(dbms_random.value(0,2))=0) then
308 p_prenume := lista_prenume_feminine(trunc(dbms_random.value(0,lista_prenume_feminine.count))+1);
309 else
310 p_prenume := lista_prenume_masculine(trunc(dbms_random.value(0,lista_prenume_masculine.count))+1);
311 end if;
312 select count(*) into p_temp1 from Angajat where nume=p_nume and prenume=p_prenume;
313 end loop;
314
315 --Status angajat si timp plecare/sosire
316
317 if(dbms_random.value(0,100) <= 50) then
318 p_status_angajat := 'In tranzit';
319 p_timp_plecare := sysdate - interval '30' minute;
320 p_timp_sosire := sysdate + interval '30' minute;
321 else
322 p_status_angajat := 'Disponibil';
323 p_timp_plecare := sysdate- interval '3' hour;
324 p_timp_sosire := sysdate - interval '2' hour;
325 end if;
326
327 insert into Angajat values(p_i, p_nume, p_prenume, p_status_angajat, p_timp_plecare, p_timp_sosire, p_timp_plecare, sysdate);
328 end loop;
329 dbms_output.put_line('S-au inserat 50 angajati.');
330
331 --Tabela Livrare
332 dbms_output.put_line('Inserare livrari.');
333 select count(IDComanda) into p_temp1 from Comanda;
334 select count(IDAngajat) into p_temp2 from Angajat;
335 for p_i in 1..p_temp1
336 loop
337 insert into Livrare values(p_i, p_i, trunc(dbms_random.value(0,p_temp2))+1, sysdate, sysdate);
338 end loop;
339 dbms_output.put_line('S-au inserat livrarile.');
340
341 --Tabela Plata
342 dbms_output.put_line('Inserare plati.');
343 select count(IDComanda) into p_temp1 from Comanda;
344 for p_i in 1..p_temp1
345 loop
346 -- Suma, Data Plata si id comanda si id mancare
347 select c.Cantitate*m.Pret, c.DataComanda, c.IDComanda into p_suma, p_data_plata, p_temp3 from Comanda c
348 join Mancare m on m.IDMancare=c.id_mancare
349 where c.IDComanda=p_i;
350
351 --Tip plata
352 if(trunc(dbms_random.value(0,2))=0) then
353 p_tip_plata := 'Cash';
354 else
355 p_tip_plata := 'Card';
356 end if;
357
358 insert into Plata values(p_i, p_suma, p_tip_plata, p_data_plata, p_temp3, sysdate, sysdate);
359 end loop;
360 dbms_output.put_line('S-au inserat platile.');
361
362 --Tabela Produs
363 dbms_output.put_line('Inserare legaturi intre produse si stoc.');
364 p_temp1 := 1;
365 p_temp2 := 0;
366 p_temp3 := 1;
367 for p_i in 1..lista_mancare.count
368 loop
369 for p_j in p_temp3..(p_temp3+lista_mancare_nr_ingrediente(p_i)-1)
370 loop
371 --Id stoc produs
372 select IDStocProdus into p_temp2 from Stoc where nume=lista_mancare_ingrediente(p_j);
373
374 insert into Produs values(p_temp1, p_i, p_temp2, sysdate, sysdate);
375 p_temp1 := p_temp1 + 1;
376 end loop;
377 p_temp3 := p_temp3 + lista_mancare_nr_ingrediente(p_i);
378 end loop;
379 dbms_output.put_line('S-au inserat legaturile.');
380
381 --Tabela IstoricComenzi
382 dbms_output.put_line('Inserare istoric comenzi.');
383 p_temp1 := 1;
384 for p_i in 1..10000
385 loop
386 for p_j in
387 (select c1.IDComanda,c1.DataComanda from Comanda c1
388 join Client c2 on c2.IDClient=c1.id_client
389 where c2.IDClient=p_i)
390 loop
391 insert into IstoricComenzi values(p_temp1, p_i, p_j.IDComanda, p_j.DataComanda, sysdate);
392 p_temp1 := p_temp1 + 1;
393 end loop;
394 end loop;
395 dbms_output.put_line('S-a inserat istoricul comenzilor.');
396end;
397/
398select count(*)|| ' clienti inserati' from Client;
399select count(*)|| ' meniuri inserate' from Meniu;
400select count(*)|| ' mancaruri inserate' from Mancare;
401select count(*)|| ' comenzi inserate' from Comanda;
402select count(*)|| ' comenzi in istoric' from IstoricComenzi;
403select count(*)|| ' plati inserate' from Plata;
404select count(*)|| ' angajati inserati' from Angajat;
405select count(*)|| ' livrari inserate' from Livrare;
406select count(*)|| ' produse inserate in stoc' from Stoc;
407select count(*)|| ' legaturi intre mancare si stoc' from Produs;