CREATE TABLE hovory
(
  jmeno      VARCHAR(20),
  tel_cislo VARCHAR(20)
);

INSERT INTO hovory VALUES('Novk', '45');
INSERT INTO hovory VALUES('Fedor', '32');
INSERT INTO hovory VALUES('Pokorn', '33');
INSERT INTO hovory VALUES('Findo', '45');
INSERT INTO hovory VALUES('Novk', '44');
INSERT INTO hovory VALUES('Pavlovi', '43');

SELECT jmeno, DECODE(tel_cislo,32, 'Belgie',
                               33, 'Francie',
                               43, 'Rakousko',
                               44, 'Velk Britanie',
                               45, 'Dnsko') FROM hovory;




CREATE TABLE monit
(
  datum     DATE,	
  stav      NUMBER(3)
);

INSERT INTO monit VALUES(TO_DATE('01.01.2002', 'dd.mm.YYYY'), 92);
INSERT INTO monit VALUES(TO_DATE('02.01.2002', 'dd.mm.YYYY') ,15); 
INSERT INTO monit VALUES(TO_DATE('03.01.2002', 'dd.mm.YYYY') ,253);

SELECT datum,
       DECODE(BITAND (stav,1)  ,1,  'dvee 1') AS "BIT 1",
       DECODE(BITAND (stav,2)  ,2,  'dvee 2') AS "BIT 2",   
       DECODE(BITAND (stav,4)  ,4,  'okno 1') AS "BIT 3",   
       DECODE(BITAND (stav,8)  ,8,  'okno 2') AS "BIT 4",   
       DECODE(BITAND (stav,16) ,16, 'napjen') AS "BIT 5",   
       DECODE(BITAND (stav,32) ,32, 'peht') AS "BIT 6",   
       DECODE(BITAND (stav,64) ,64, 'por') AS "BIT 7",   
       DECODE(BITAND (stav,128),128,'zatopen') AS "BIT 8"   
FROM monit;



CREATE TABLE zam_oddeleni
(
  jmeno     VARCHAR2(15),	
  mzda      NUMBER(8,2)
);

INSERT INTO zam_oddeleni VALUES('Novk',     5280.25);
INSERT INTO zam_oddeleni VALUES('Fedor',    12344.50);
INSERT INTO zam_oddeleni VALUES('Pokorn',   3600.00);
INSERT INTO zam_oddeleni VALUES('Findo',     8260.25);
INSERT INTO zam_oddeleni VALUES('Pavlovi', 15999.00);
INSERT INTO zam_oddeleni VALUES('Pukanov', 7250.75);
INSERT INTO zam_oddeleni VALUES('Fen',     4100.25);
INSERT INTO zam_oddeleni VALUES('Zajek',  45820.00);
INSERT INTO zam_oddeleni VALUES('Kocbek',  13710.00);
INSERT INTO zam_oddeleni VALUES('Kucek',    11300.50);


SELECT jmeno, mzda, WIDTH_BUCKET(mzda, 4000, 20000,5) 
FROM zam_oddeleni;


CREATE TABLE lide 
(
  jmeno           VARCHAR2(30),
  r_cislo         CHAR(11)
);
 
INSERT INTO lide VALUES ('Novk Alfons','650327/6153');
INSERT INTO lide VALUES ('Plha Jan','720711/1109');
INSERT INTO lide VALUES ('Kecal Josef','850505/2222');
INSERT INTO lide VALUES ('Kubkov Jana','705315/1105');

