1,840
 2,300,180,300,300,300,180,420
 3,540,240,360,240,300,180,180
 4,240,180,300,300,360,240,360,300
 5,240,540,360,420,240,420,240,180

T_T1
---
L_ID (fixée à 'A')
T1_ID (premier caractère des lignes)
 
et
 
T_T2
---
L_ID (fixée à 'A')
T1_ID (premier caractère des lignes)
T2_ID (SEQUENCE)
T2_TEMPS (les chiffres suivants le premier chiffre)

LOAD DATA INFILE 'tpsa.csv'
REPLACE
INTO TABLE T_T1
FIELDS TERMINATED BY ','
(
 L_ID CONSTANT 'A',  
 T1_ID INTEGER EXTERNAL
)
INTO TABLE T_T2
FIELDS TERMINATED BY ','
TRAILING NULLCOLS
(
 L_ID CONSTANT 'A',  
 T1_ID INTEGER EXTERNAL,  
 T2_ID SEQUENCE(1, 1),  
 T2_TEMPS VARRAY TERMINATED BY "\r\n"
 (
  T2_TEMPS INTEGER EXTERNAL
 )
)