Steuerdatei
LOAD DATA
INFILE 'ulcase2.dat'
INTO TABLE EMP
(
EMPNO
POSITION(01:04)
INTEGER EXTERNAL,
ENAME
POSITION(06:15)
CHAR,
JOB
POSITION(17:25)
CHAR,
MGR
POSITION(27:30)
INTEGER EXTERNAL,
SAL
POSITION(32:39)
COMM
POSITION(41:48)
DECIMAL EXTERNAL,
DEPTNO
POSITION(50:51)
INTEGER EXTERNAL
)
Datendatei
7782 CLARK MANAGER 7839 2572.50 10
7839 KING PRESIDENT 5500.00 10
7934 MILLER CLERK 7782 920.00 10
7566 JONES MANAGER 7839 3123.75 20
7499 ALLEN SALESMAN 7698 1600.00 300.00 30
7654 MARTIN SALESMAN 7698 1312.50 1400.00 30
7658 CHAN ANALYST 7566 3450.00 20