CREATE TABLE videokazety
(
    ev_cislo  NUMBER(4) PRIMARY KEY,
    nazev     VARCHAR2(15) 
);

INSERT INTO videokazety VALUES(1, 'Pocahontas');
INSERT INTO videokazety VALUES(2, 'Lion King');
INSERT INTO videokazety VALUES(3, 'Cinderella');
INSERT INTO videokazety VALUES(4, 'Mickey');
INSERT INTO videokazety VALUES(5, 'Donald');
COMMIT;



SELECT empno||','
       ||''''||ename||''''||','
       ||''''||job||''''||','
       ||mgr||','
       ||''''||hiredate||''''||','
       ||sal||','
       ||comm||','
       ||deptno
FROM emp;


SET heading off
SET feedback off
SET echo off
SET pagesize 0
SPOOL c:\emp_flat.dat
SELECT empno||','
       ||'"'||ename||'"'||','
       ||'"'||job||'"'||','
       ||mgr||','
       ||'"'||hiredate||'"'||','
       ||sal||','
       ||comm||','
       ||deptnoFROM emp;
SPOOL off


CREATE TABLE emp_flat 
(
  empno    NUMBER(4) NOT NULL,
  ename    VARCHAR2(10),
  job      VARCHAR2(9),
  mgr      NUMBER(4),
  hiredate DATE,
  sal      NUMBER(7,2),
  comm     NUMBER(7,2),
  deptno   NUMBER(2)
);
