---
ALTER SESSION SET NLS_DATE_LANGUAGE = ENGLISH;
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY';
--- 

DROP TABLE DOLGOZO;
DROP TABLE OSZTALY;
DROP TABLE BONUS;
DROP TABLE FIZKAT;
DROP TABLE TETEL;
DROP TABLE ARLISTA;
DROP TABLE TERMEKEK;
DROP TABLE RENDEL;
DROP TABLE VEVO;
DROP VIEW ELAD;
DROP SEQUENCE RKOD;
DROP SEQUENCE VKOD;
DROP SEQUENCE TKOD;

CREATE TABLE OSZTALY (
 OAZON              NUMBER(2) NOT NULL,
 ONEV               VARCHAR2(14),
 TELEPHELY          VARCHAR2(13),
 CONSTRAINT OSZT_PK PRIMARY KEY (OAZON));

INSERT INTO OSZTALY VALUES (10,'ACCOUNTING','NEW YORK');
INSERT INTO OSZTALY VALUES (20,'RESEARCH','DALLAS');
INSERT INTO OSZTALY VALUES (30,'SALES','CHICAGO');
INSERT INTO OSZTALY VALUES (40,'OPERATIONS','BOSTON');

CREATE TABLE DOLGOZO (
 DKOD               NUMBER(4) NOT NULL,
 DNEV               VARCHAR2(10),
 FOGLALKOZAS        VARCHAR2(9),
 FONOKE             NUMBER(4) CONSTRAINT DOLG_SELF_KEY REFERENCES DOLGOZO (DKOD),
 BELEPES            DATE,
 FIZETES            NUMBER(7,2),
 JUTALEK            NUMBER(7,2),
 OAZON              NUMBER(2),
 CONSTRAINT DOLG_FK FOREIGN KEY (OAZON) REFERENCES OSZTALY (OAZON),
 CONSTRAINT DOLG_PK PRIMARY KEY (DKOD));

INSERT INTO DOLGOZO VALUES (7839,'KING','PRESIDENT',NULL,'17-NOV-1981',5000,NULL,10);
INSERT INTO DOLGOZO VALUES (7698,'BLAKE','MANAGER',7839,'1-MAY-1981',2850,NULL,30);
INSERT INTO DOLGOZO VALUES (7782,'CLARK','MANAGER',7839,'9-JUN-1981',2450,NULL,10);
INSERT INTO DOLGOZO VALUES (7566,'JONES','MANAGER',7839,'2-APR-1981',2975,NULL,20);
INSERT INTO DOLGOZO VALUES (7654,'MARTIN','SALESMAN',7698,'28-SEP-1981',1250,1400,30);
INSERT INTO DOLGOZO VALUES (7499,'ALLEN','SALESMAN',7698,'20-FEB-1981',1600,300,30);
INSERT INTO DOLGOZO VALUES (7844,'TURNER','SALESMAN',7698,'8-SEP-1981',1500,0,30);
INSERT INTO DOLGOZO VALUES (7900,'JAMES','CLERK',7698,'3-DEC-1981',950,NULL,30);
INSERT INTO DOLGOZO VALUES (7521,'WARD','SALESMAN',7698,'22-FEB-1981',1250,500,30);
INSERT INTO DOLGOZO VALUES (7902,'FORD','ANALYST',7566,'3-DEC-1981',3000,NULL,20);
INSERT INTO DOLGOZO VALUES (7369,'SMITH','CLERK',7902,'17-DEC-1980',800,NULL,20);
INSERT INTO DOLGOZO VALUES (7788,'SCOTT','ANALYST',7566,'09-DEC-1982',3000,NULL,20);
INSERT INTO DOLGOZO VALUES (7876,'ADAMS','CLERK',7788,'12-JAN-1983',1100,NULL,20);
INSERT INTO DOLGOZO VALUES (7934,'MILLER','CLERK',7782,'23-JAN-1982',1300,NULL,10);
INSERT INTO Dolgozo VALUES (7877,'LOLA','CLERK',7902,'12-JAN-1981',800,NULL,NULL);
INSERT INTO Dolgozo VALUES (7878,'BLACK',NULL,7902,'01-MAY-1987',1800,300,NULL);

CREATE TABLE BONUS (
 DNEV               VARCHAR2(10),
 FOGLALKOZAS        VARCHAR2(9),
 FIZETES            NUMBER,
 JUTALEK            NUMBER);

CREATE TABLE FIZKAT (
 KATEGORIA          NUMBER,
 ALSO               NUMBER,
 FELSO              NUMBER);

INSERT INTO FIZKAT VALUES (1,700,1200);
INSERT INTO FIZKAT VALUES (2,1201,1400);
INSERT INTO FIZKAT VALUES (3,1401,2000);
INSERT INTO FIZKAT VALUES (4,2001,3000);
INSERT INTO FIZKAT VALUES (5,3001,9999);

--- 

CREATE TABLE VEVO (
 VKOD              NUMBER (6) NOT NULL,
 VNEV              VARCHAR2 (45),
 LAKCIM            VARCHAR2 (40),
 VAROS             VARCHAR2 (30),
 ALLAM             VARCHAR2 (2),
 IRSZAM            VARCHAR2 (9),
 KER               NUMBER (3),
 TEL               VARCHAR2 (9),
 VAZON             NUMBER (4) NOT NULL,
 CREDITLIMIT       NUMBER (9,2),
 MEGJ              LONG,
 CONSTRAINT VEVO_VKOD_PK PRIMARY KEY (VKOD),
 CONSTRAINT VEVO_VKOD_CK CHECK (VKOD > 0));


INSERT INTO VEVO (IRSZAM, ALLAM, VAZON, TEL, VNEV, VKOD, CREDITLIMIT,
  VAROS, KER, LAKCIM, MEGJ)
VALUES ('96711', 'CA', '7844', '598-6609',
 'JOCKSPORTS',
 '100', '5000', 'BELMONT', '415', '345 VIEWRIDGE',
 'Very friendly people to work with -- sales rep likes to be called Mike.');
INSERT INTO VEVO (IRSZAM, ALLAM, VAZON, TEL, VNEV, VKOD, CREDITLIMIT,
  VAROS, KER, LAKCIM, MEGJ)
VALUES ('94061', 'CA', '7521', '368-1223',
 'TKB SPORT SHOP',
 '101', '10000', 'REDWOOD CITY', '415', '490 BOLI RD.',
 'Rep called 5/8 about change in order - contact shipping.');
INSERT INTO VEVO (IRSZAM, ALLAM, VAZON, TEL, VNEV, VKOD, CREDITLIMIT,
  VAROS, KER, LAKCIM, MEGJ)
VALUES ('95133', 'CA', '7654', '644-3341',
 'VOLLYRITE',
 '102', '7000', 'BURLINGAME', '415', '9722 HAMILTON',
 'Company doing heavy promotion beginning 10/89. Prepare for large orders during
 winter.');
INSERT INTO VEVO (IRSZAM, ALLAM, VAZON, TEL, VNEV, VKOD, CREDITLIMIT,
  VAROS, KER, LAKCIM, MEGJ)
VALUES ('97544', 'CA', '7521', '677-9312',
 'JUST TENNIS',
 '103', '3000', 'BURLINGAME', '415', 'HILLVIEW MALL',
 'Contact rep about new line of tennis rackets.');
INSERT INTO VEVO (IRSZAM, ALLAM, VAZON, TEL, VNEV, VKOD, CREDITLIMIT,
  VAROS, KER, LAKCIM, MEGJ)
VALUES ('93301', 'CA', '7499', '996-2323',
 'EVERY MOUNTAIN',
 '104', '10000', 'CUPERTINO', '408', '574 SURRY RD.',
 'Customer with high market share (23%) due to aggressive advertising.');
INSERT INTO VEVO (IRSZAM, ALLAM, VAZON, TEL, VNEV, VKOD, CREDITLIMIT,
  VAROS, KER, LAKCIM, MEGJ)
VALUES ('91003', 'CA', '7844', '376-9966',
 'K + T SPORTS',
 '105', '5000', 'SANTA CLARA', '408', '3476 EL PASEO',
 'Tends to order large amounts of merchandise at once. Accounting is considering
 raising their credit limit. Usually pays on time.');
INSERT INTO VEVO (IRSZAM, ALLAM, VAZON, TEL, VNEV, VKOD, CREDITLIMIT,
  VAROS, KER, LAKCIM, MEGJ)
VALUES ('94301', 'CA', '7521', '364-9777',
 'SHAPE UP',
 '106', '6000', 'PALO ALTO', '415', '908 SEQUOIA',
 'Support intensive. Orders small amounts (< 800) of merchandise at a time.');
INSERT INTO VEVO (IRSZAM, ALLAM, VAZON, TEL, VNEV, VKOD, CREDITLIMIT,
  VAROS, KER, LAKCIM, MEGJ)
VALUES ('93301', 'CA', '7499', '967-4398',
 'WOMENS SPORTS',
 '107', '10000', 'SUNNYVALE', '408', 'VALCO VILLAGE',
 'First sporting goods store geared exclusively towards women. Unusual promotion
al style and very willing to take chances towards new products!');
INSERT INTO VEVO (IRSZAM, ALLAM, VAZON, TEL, VNEV, VKOD, CREDITLIMIT,
  VAROS, KER, LAKCIM, MEGJ)
VALUES ('55649', 'MN', '7844', '566-9123',
 'NORTH WOODS HEALTH AND FITNESS SUPPLY CENTER',
 '108', '8000', 'HIBBING', '612', '98 LONE PINE WAY', '');


CREATE TABLE RENDEL  (
 RKOD               NUMBER (4) NOT NULL,
 RENDELES           DATE,
 TERV            VARCHAR2 (1),
 VKOD               NUMBER (6) NOT NULL,
 SZALLITAS          DATE,
 MENNYI              NUMBER (8,2) CONSTRAINT RENDEL_MENNYI_CK CHECK (MENNYI >= 0),
 CONSTRAINT RENDEL_VKOD_FK FOREIGN KEY (VKOD) REFERENCES VEVO (VKOD),
 CONSTRAINT RENDEL_RKOD_PK PRIMARY KEY (RKOD));

INSERT INTO RENDEL (MENNYI, SZALLITAS, RKOD, RENDELES, VKOD, TERV)
 VALUES ('101', '08-JAN-1987', '610', '07-JAN-1987', '101', 'A');
INSERT INTO RENDEL (MENNYI, SZALLITAS, RKOD, RENDELES, VKOD, TERV)
 VALUES ('45', '11-JAN-1987', '611', '11-JAN-1987', '102', 'B');
INSERT INTO RENDEL (MENNYI, SZALLITAS, RKOD, RENDELES, VKOD, TERV)
 VALUES ('5860', '20-JAN-1987', '612', '15-JAN-1987', '104', 'C');
INSERT INTO RENDEL (MENNYI, SZALLITAS, RKOD, RENDELES, VKOD, TERV)
 VALUES ('2', '30-MAY-1986', '601', '01-MAY-1986', '106', 'A');
INSERT INTO RENDEL (MENNYI, SZALLITAS, RKOD, RENDELES, VKOD, TERV)
 VALUES ('56', '20-JUN-1986', '602', '05-JUN-1986', '102', 'B');
INSERT INTO RENDEL (MENNYI, SZALLITAS, RKOD, RENDELES, VKOD, TERV)
 VALUES ('698', '30-JUN-1986', '604', '15-JUN-1986', '106', 'A');
INSERT INTO RENDEL (MENNYI, SZALLITAS, RKOD, RENDELES, VKOD, TERV)
 VALUES ('8324', '30-JUL-1986', '605', '14-JUL-1986', '106', 'A');
INSERT INTO RENDEL (MENNYI, SZALLITAS, RKOD, RENDELES, VKOD, TERV)
 VALUES ('3', '30-JUL-1986', '606', '14-JUL-1986', '100', 'A');
INSERT INTO RENDEL (MENNYI, SZALLITAS, RKOD, RENDELES, VKOD, TERV)
 VALUES ('97', '15-AUG-1986', '609', '01-AUG-1986', '100', 'B');
INSERT INTO RENDEL (MENNYI, SZALLITAS, RKOD, RENDELES, VKOD, TERV)
 VALUES ('6', '18-JUL-1986', '607', '18-JUL-1986', '104', 'C');
INSERT INTO RENDEL (MENNYI, SZALLITAS, RKOD, RENDELES, VKOD, TERV)
 VALUES ('35', '25-JUL-1986', '608', '25-JUL-1986', '104', 'C');
INSERT INTO RENDEL (MENNYI, SZALLITAS, RKOD, RENDELES, VKOD, TERV)
 VALUES ('224', '05-JUN-1986', '603', '05-JUN-1986', '102', '');
INSERT INTO RENDEL (MENNYI, SZALLITAS, RKOD, RENDELES, VKOD, TERV)
 VALUES ('4450', '12-MAR-1987', '620', '12-MAR-1987', '100', '');
INSERT INTO RENDEL (MENNYI, SZALLITAS, RKOD, RENDELES, VKOD, TERV)
 VALUES ('6400', '01-FEB-1987', '613', '01-FEB-1987', '108', '');
INSERT INTO RENDEL (MENNYI, SZALLITAS, RKOD, RENDELES, VKOD, TERV)
 VALUES ('23940', '05-FEB-1987', '614', '01-FEB-1987', '102', '');
INSERT INTO RENDEL (MENNYI, SZALLITAS, RKOD, RENDELES, VKOD, TERV)
 VALUES ('764', '10-FEB-1987', '616', '03-FEB-1987', '103', '');
INSERT INTO RENDEL (MENNYI, SZALLITAS, RKOD, RENDELES, VKOD, TERV)
 VALUES ('1260', '04-FEB-1987', '619', '22-FEB-1987', '104', '');
INSERT INTO RENDEL (MENNYI, SZALLITAS, RKOD, RENDELES, VKOD, TERV)
 VALUES ('46370', '03-MAR-1987', '617', '05-FEB-1987', '105', '');
INSERT INTO RENDEL (MENNYI, SZALLITAS, RKOD, RENDELES, VKOD, TERV)
 VALUES ('710', '06-FEB-1987', '615', '01-FEB-1987', '107', '');
INSERT INTO RENDEL (MENNYI, SZALLITAS, RKOD, RENDELES, VKOD, TERV)
 VALUES ('3510', '06-MAR-1987', '618', '15-FEB-1987', '102', 'A');
INSERT INTO RENDEL (MENNYI, SZALLITAS, RKOD, RENDELES, VKOD, TERV)
 VALUES ('730', '01-JAN-1987', '621', '15-MAR-1987', '100', 'A');


CREATE TABLE TETEL  (
 RKOD               NUMBER (4) NOT NULL,
 TETELSZ            NUMBER (4) NOT NULL,
 TKOD               NUMBER (6),
 ACTUALAR           NUMBER (8,2),
 MENNYISEG          NUMBER (8),
 OSSZ               NUMBER (8,2),
 CONSTRAINT TETEL_RKOD_FK FOREIGN KEY (RKOD) REFERENCES RENDEL (RKOD),
 CONSTRAINT TETEL_RKOD_TETELSZ_PK PRIMARY KEY (RKOD,TETELSZ));

INSERT INTO TETEL (MENNYISEG, TKOD, RKOD, OSSZ, TETELSZ, ACTUALAR)
 VALUES ('1', '100890', '610', '58', '3', '58');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ( '1', '100861', '611', '45', '1', '45');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ( '100', '100860', '612', '3000', '1', '30');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ( '1', '200376', '601', '2', '1', '2');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ( '20', '100870', '602', '56', '1', '3');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ( '3', '100890', '604', '174', '1', '58');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ( '2', '100861', '604', '84', '2', '42');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ( '10', '100860', '604', '440', '3', '44');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ( '4', '100860', '603', '224', '2', '56');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ( '1', '100860', '610', '35', '1', '35');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ( '3', '100870', '610', '8', '2', '3');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ( '200', '200376', '613', '440', '4', '2');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ( '444', '100860', '614', '15540', '1', '35');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ( '1000', '100870', '614', '2800', '2', '3');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ( '20', '100861', '612', '810', '2', '40');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('150', '101863', '612', '1500', '3', '10');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('10', '100860', '620', '350', '1', '35');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('1000', '200376', '620', '2400', '2', '2');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('500', '102130', '620', '1700', '3', '3');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ( '100', '100871', '613', '560', '1', '6');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('200', '101860', '613', '4800', '2', '24');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('150', '200380', '613', '600', '3', '4');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('100', '102130', '619', '340', '3', '3');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('50', '100860', '617', '1750', '1', '35');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('100', '100861', '617', '4500', '2', '45');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('1000', '100871', '614', '5600', '3', '6');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('10', '100861', '616', '450', '1', '45');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('50', '100870', '616', '140', '2', '3');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('2', '100890', '616', '116', '3', '58');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('10', '102130', '616', '34', '4', '3');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('10', '200376' , '616', '24', '5', '2');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('100', '200380', '619', '400', '1', '4');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('100', '200376', '619', '240', '2', '2');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('4', '100861', '615', '180', '1', '45');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('1', '100871', '607', '6', '1', '6');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('100', '100870', '615', '280', '2', '3');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('500', '100870', '617', '1400', '3', '3');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('500', '100871', '617', '2800', '4', '6');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('500', '100890', '617', '29000', '5', '58');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('100', '101860', '617', '2400', '6', '24');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('200', '101863', '617', '2500', '7', '12');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('100', '102130', '617', '340', '8', '3');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('200', '200376', '617', '480', '9', '2');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('300', '200380', '617', '1200', '10', '4');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('5', '100870', '609', '12', '2', '2');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('1', '100890', '609', '50', '3', '50');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('23', '100860', '618', '805', '1', '35');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('50', '100861', '618', '2255', '2', '451');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('10', '100870', '618', '450', '3', '45');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('10', '100861', '621', '450', '1', '45');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('100', '100870', '621', '280', '2', '3');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('50', '100871', '615', '250', '3', '5');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('1', '101860', '608', '24', '1', '24');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('2', '100871', '608', '11', '2', '6');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('1', '100861', '609', '35', '1', '35');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('1', '102130', '606', '3', '1', '3');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('100', '100861', '605', '4500', '1', '45');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('500', '100870', '605', '1400', '2', '3');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('5', '100890', '605', '290', '3', '58');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('50', '101860', '605', '1200', '4', '24');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('100', '101863', '605', '900', '5', '9');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('10', '102130', '605', '34', '6', '3');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('100', '100871', '612', '550', '4', '5');
INSERT INTO TETEL ( MENNYISEG , TKOD , RKOD , OSSZ , TETELSZ , ACTUALAR)
 VALUES ('50', '100871', '619', '280', '4', '6');


CREATE TABLE TERMEKEK (
 TKOD               NUMBER (6) CONSTRAINT TERMEKEK_PK PRIMARY KEY,
 LEIRAS             VARCHAR2 (30));

INSERT INTO TERMEKEK (TKOD, LEIRAS)
 VALUES ('100860', 'ACE TENNIS RACKET I');
INSERT INTO TERMEKEK (TKOD, LEIRAS)
 VALUES ('100861', 'ACE TENNIS RACKET II');
INSERT INTO TERMEKEK (TKOD, LEIRAS)
 VALUES ('100870', 'ACE TENNIS BALLS-3 PACK');
INSERT INTO TERMEKEK (TKOD, LEIRAS)
 VALUES ('100871', 'ACE TENNIS BALLS-6 PACK');
INSERT INTO TERMEKEK (TKOD, LEIRAS)
 VALUES ('100890', 'ACE TENNIS NET');
INSERT INTO TERMEKEK (TKOD, LEIRAS)
 VALUES ('101860', 'SP TENNIS RACKET');
INSERT INTO TERMEKEK (TKOD, LEIRAS)
 VALUES ('101863', 'SP JUNIOR RACKET');
INSERT INTO TERMEKEK (TKOD, LEIRAS)
 VALUES ('102130', 'RH: "GUIDE TO TENNIS"');
INSERT INTO TERMEKEK (TKOD, LEIRAS)
 VALUES ('200376', 'SB ENERGY BAR-6 PACK');
INSERT INTO TERMEKEK (TKOD, LEIRAS)
 VALUES ('200380', 'SB VITA SNACK-6 PACK');


CREATE TABLE ARLISTA (
 TKOD              NUMBER (6) NOT NULL,
 STDAR             NUMBER (8,2),
 MINAR             NUMBER (8,2),
 KEZDETE           DATE,
 VEGE              DATE);

INSERT INTO ARLISTA (STDAR, KEZDETE, TKOD, MINAR, VEGE)
 VALUES ('5', '01-JAN-1985', '100871', '3', '01-DEC-1985');
INSERT INTO ARLISTA (STDAR, KEZDETE, TKOD, MINAR, VEGE)
 VALUES ('58', '01-JAN-1985', '100890', '46', '');
INSERT INTO ARLISTA (STDAR, KEZDETE, TKOD, MINAR, VEGE)
 VALUES ('54', '01-JUN-1984', '100890', '40', '31-MAY-1984');
INSERT INTO ARLISTA (STDAR, KEZDETE, TKOD, MINAR, VEGE)
 VALUES ('35', '01-JUN-1986', '100860', '28', '');
INSERT INTO ARLISTA (STDAR, KEZDETE, TKOD, MINAR, VEGE)
 VALUES ('32', '01-JAN-1986', '100860', '26', '31-MAY-1986');
INSERT INTO ARLISTA (STDAR, KEZDETE, TKOD, MINAR, VEGE)
 VALUES ('30', '01-JAN-1985', '100860', '24', '31-DEC-1985');
INSERT INTO ARLISTA (STDAR, KEZDETE, TKOD, MINAR, VEGE)
 VALUES ('45', '01-JUN-1986', '100861', '36', '');
INSERT INTO ARLISTA (STDAR, KEZDETE, TKOD, MINAR, VEGE)
 VALUES ('42', '01-JAN-1986', '100861', '34', '31-MAY-1986');
INSERT INTO ARLISTA (STDAR, KEZDETE, TKOD, MINAR, VEGE)
 VALUES ('39', '01-JAN-1985', '100861', '31', '31-DEC-1985');
INSERT INTO ARLISTA (STDAR, KEZDETE, TKOD, MINAR, VEGE)
 VALUES ('3', '01-JAN-1986', '100870', '2', '');
INSERT INTO ARLISTA (STDAR, KEZDETE, TKOD, MINAR, VEGE)
 VALUES ('2', '01-JAN-1985', '100870', '2', '01-DEC-1985');
INSERT INTO ARLISTA (STDAR, KEZDETE, TKOD, MINAR, VEGE)
 VALUES ('6', '01-JAN-1986', '100871', '5', '');
INSERT INTO ARLISTA (STDAR, KEZDETE, TKOD, MINAR, VEGE)
 VALUES ('24', '15-FEB-1985', '101860', '18', '');
INSERT INTO ARLISTA (STDAR, KEZDETE, TKOD, MINAR, VEGE)
 VALUES ('12', '15-FEB-1985', '101863', '9', '');
INSERT INTO ARLISTA (STDAR, KEZDETE, TKOD, MINAR, VEGE)
 VALUES ('3', '18-AUG-1985', '102130', '3', '');
INSERT INTO ARLISTA (STDAR, KEZDETE, TKOD, MINAR, VEGE)
 VALUES ('2', '15-NOV-1986', '200376', '2', '');
INSERT INTO ARLISTA (STDAR, KEZDETE, TKOD, MINAR, VEGE)
 VALUES ('4', '15-NOV-1986', '200380', '3', '');

CREATE INDEX ARLISTA_INDEX ON ARLISTA(TKOD, KEZDETE);

CREATE SEQUENCE RKOD
INCREMENT BY 1
START WITH 622
NOCACHE;

CREATE SEQUENCE TKOD
INCREMENT BY 1
START WITH 200381
NOCACHE;

CREATE SEQUENCE VKOD
INCREMENT BY 1
START WITH 109
NOCACHE;

CREATE VIEW ELAD AS
SELECT VAZON, RENDEL.VKOD, VEVO.VNEV VEVONEV, TERMEKEK.TKOD,
LEIRAS TERMEKNEV, SUM(OSSZ) MENNYISEG
FROM RENDEL, TETEL, VEVO, TERMEKEK
WHERE RENDEL.RKOD = TETEL.RKOD
AND RENDEL.VKOD = VEVO.VKOD
AND TETEL.TKOD = TERMEKEK.TKOD
GROUP BY VAZON, RENDEL.VKOD, VNEV, TERMEKEK.TKOD, LEIRAS;

COMMIT; 

GRANT SELECT ON DOLGOZO TO PUBLIC; 
GRANT SELECT ON OSZTALY TO PUBLIC; 
GRANT SELECT ON BONUS TO PUBLIC; 
GRANT SELECT ON FIZKAT TO PUBLIC; 
GRANT SELECT ON TETEL TO PUBLIC; 
GRANT SELECT ON ARLISTA TO PUBLIC; 
GRANT SELECT ON TERMEKEK TO PUBLIC; 
GRANT SELECT ON RENDEL TO PUBLIC; 
GRANT SELECT ON VEVO TO PUBLIC; 
GRANT SELECT ON ELAD TO PUBLIC; 

--- 
ALTER SESSION SET NLS_DATE_LANGUAGE = HUNGARIAN;
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY.MM.DD';
---
SELECT * FROM DOLGOZO;
SELECT * FROM OSZTALY;
SELECT * FROM BONUS;
SELECT * FROM FIZKAT;
SELECT * FROM TETEL;
SELECT * FROM ARLISTA;
SELECT * FROM TERMEKEK;
SELECT * FROM RENDEL;
SELECT * FROM VEVO;
SELECT * FROM ELAD;