1 2 3 4 5 6 7
| SELECT SUBSTR(MONCHAMP, 1, INSTR(MONCHAMP, '~', 1, 1) - 1) AS NOM,
SUBSTR(MONCHAMP, INSTR(MONCHAMP, '~', 1, 1) + 1, INSTR(MONCHAMP, '~', 1, 2) - INSTR(MONCHAMP, '~', 1, 1) - 1) AS PRENOM,
SUBSTR(MONCHAMP, INSTR(MONCHAMP, '~', 1, 2) + 1, INSTR(MONCHAMP, '~', 1, 3) - INSTR(MONCHAMP, '~', 1, 2) - 1) AS ADRESSE,
SUBSTR(MONCHAMP, INSTR(MONCHAMP, '~', 1, 3) + 1, INSTR(MONCHAMP, '~', 1, 4) - INSTR(MONCHAMP, '~', 1, 3) - 1) AS CODEPOSTAL,
SUBSTR(MONCHAMP, INSTR(MONCHAMP, '~', 1, 4) + 1, LENGTH(MONCHAMP) - INSTR(MONCHAMP, '~', 1, 4) ) AS VILLE
FROM
(SELECT 'NOM~PRENOM~ADRESSE~CODEPOSTAL~VILLE' MONCHAMP FROM DUAL); |
Partager