1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| WITH matable (macolonne) AS
(
SELECT '3- AAAA' FROM dual UNION ALL
SELECT 'P- BBBB' FROM dual UNION ALL
SELECT 'SE: CCCC' FROM dual UNION ALL
SELECT '1- DDDD' FROM dual UNION ALL
SELECT '2- EEEE' FROM dual UNION ALL
SELECT 'C- FFFF' FROM dual UNION ALL
SELECT 'P3- GGGG' FROM dual UNION ALL
SELECT 'S- HHH' FROM dual UNION ALL
SELECT '4- IIII' FROM dual UNION ALL
SELECT 'F- JJJJ' FROM dual UNION ALL
SELECT '0- KKKK' FROM dual UNION ALL
SELECT 'R+: LLLL' FROM dual UNION ALL
SELECT '2R+' FROM dual UNION ALL
SELECT 'R- MMMM' FROM dual UNION ALL
SELECT 'R3- NNN' FROM dual UNION ALL
SELECT 'R12' FROM dual
)
SELECT macolonne,
CASE WHEN INSTR(REPLACE(macolonne, ':','-'), '-') > 0 THEN SUBSTR(macolonne, 1, INSTR(REPLACE(macolonne, ':','-'), '-')-1) ELSE macolonne END deb,
CASE WHEN INSTR(REPLACE(macolonne, ':','-'), '-') > 0 THEN LTRIM(SUBSTR(macolonne, INSTR(REPLACE(macolonne, ':','-'), '-')+1)) ELSE '' END fin
FROM matable; |
Partager