1 2 3 4 5 6 7 8
| SELECT SUBSTR(ligne, INSTR(ligne, '@',1,1)+1, INSTR(ligne, '@', 1,2) - INSTR(ligne, '@',1,1) -1) AS col1,
SUBSTR(ligne, INSTR(ligne, '@',1,2)+1, INSTR(ligne, '@', 1,3) - INSTR(ligne, '@',1,2) -1) AS col2,
SUBSTR(ligne, INSTR(ligne, '@',1,3)+1, INSTR(ligne, '@', 1,4) - INSTR(ligne, '@',1,3) -1) AS col3,
SUBSTR(ligne, INSTR(ligne, '@',1,4)+1, INSTR(ligne, '@', 1,5) - INSTR(ligne, '@',1,4) -1) AS col4
FROM (SELECT '@1@A@I@20071213@FRP@SEATRADE@BEP@PAP@FRIO HELLENIC@@@N@' ligne FROM dual)
COL1 COL2 COL3 COL4
1 A I 20071213 |
Partager