LOAD DATA
INFILE 'D:\loader\ULY02.01070839.BTM'
APPEND

INTO TABLE T1
WHEN TABCODE_ID = '1'
FIELDS TERMINATED BY '|' TRAILING NULLCOLS
(
TABCODE_ID FILLER POSITION (1) INTEGER EXTERNAL,
F1 INTEGER EXTERNAL,
F2 CHAR,
F3 INTEGER EXTERNAL,
F4 DATE "DD-MON-YYYY HH24:MI:SS",
)

INTO TABLE T1
WHEN TABCODE_ID = '2'
FIELDS TERMINATED BY '|' TRAILING NULLCOLS
(
TABCODE_ID FILLER POSITION (1) INTEGER EXTERNAL,
F1 INTEGER EXTERNAL,
F2 CHAR,
F3 INTEGER EXTERNAL,
F4 DATE "DD-MON-YYYY HH24:MI:SS",
)

INTO TABLE T1
WHEN TABCODE_ID = '3'
FIELDS TERMINATED BY '|' TRAILING NULLCOLS
(
TABCODE_ID FILLER POSITION (1) INTEGER EXTERNAL,
F1 INTEGER EXTERNAL,
F2 CHAR,
F3 INTEGER EXTERNAL,
F4 DATE "DD-MON-YYYY HH24:MI:SS",
)

 ....
 ....
 ....
 ....
 ....
 
 INTO TABLE T200
WHEN TABCODE_ID = '200'
FIELDS TERMINATED BY '|' TRAILING NULLCOLS
(
TABCODE_ID FILLER POSITION (1) INTEGER EXTERNAL,
F1 INTEGER EXTERNAL,
F2 CHAR,
F3 INTEGER EXTERNAL,
F4 DATE "DD-MON-YYYY HH24:MI:SS",
)

Table T1:
  200 Rows successfully loaded.
  0 Rows not loaded due to data errors.
  5000 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.


Table T2:
  500 Rows successfully loaded.
  0 Rows not loaded due to data errors.
  5000 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.


Table T3:
  600 Rows successfully loaded.
  0 Rows not loaded due to data errors.
  5000 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.


Table T4:
  0 Rows successfully loaded.
  0 Rows not loaded due to data errors.
  5000 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.

Table T5:
  0 Rows successfully loaded.
  0 Rows not loaded due to data errors.
  5000 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.


Table T6:
  0 Rows successfully loaded.
  0 Rows not loaded due to data errors.
  5000 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.

Table T7:
  0 Rows successfully loaded.
  0 Rows not loaded due to data errors.
  5000 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.

Table T8:
  0 Rows successfully loaded.
  0 Rows not loaded due to data errors.
  5000 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.

...
...
...
...

Table T200:
  0 Rows successfully loaded.
  0 Rows not loaded due to data errors.
  5000 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.


Space allocated for bind array:                 591594 bytes(1 rows)
Read   buffer bytes: 1048576

Total logical records skipped:          0
Total logical records read:          4944
Total logical records rejected:         0
Total logical records discarded:        0

Run began on Fri Jan 08 14:28:13 2010
Run ended on Fri Jan 08 15:04:03 2010

Elapsed time was:     00:35:49.39
CPU time was:         00:00:24.72

select f1, f2, f3, to_char(f4, 'dd.mm.yyyy hh24:mi:ss') f_4
from t1
where ...;

select f1, f2, f3, to_char(f4, 'dd.mm.yyyy hh24:mi:ss') f_4
from t3
where ...;

select f1, f2, f3, to_char(f4, 'dd.mm.yyyy hh24:mi:ss') f_4
from t3
where ...;

etc.

select f1, f2, f3, to_char(f4, 'dd.mm.yyyy hh24:mi:ss') f_4
from one_table
where id = <id you are interested in>
  and ...