1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| with cte_matable (id, col) as
(
select 1, 'Volumes Clients: 10167 - Véhicules: 10189' from dual union all
select 2, 'Volumes Clients: 29559 - Véhicules: 29885' from dual union all
select 3, 'Volumes Clients: 1637 - Véhicules: 1638' from dual union all
select 4, 'Volumes Clients: 17513 - Véhicules: 17689' from dual union all
select 5, 'Volumes Clients: 172004 - Véhicules: 173657' from dual
)
select id, col
, substr(col, 18, instr(col, '-') - instr(col, ':') - 3) as vol_clients
, substr(col, instr(col, ':', 1, 2) + 2) as vol_vehicules
from cte_matable;
ID COL VOL_CLIENTS VOL_VEHICULES
-- ------------------------------------------- ------------ -------------
1 Volumes Clients: 10167 - Véhicules: 10189 10167 10189
2 Volumes Clients: 29559 - Véhicules: 29885 29559 29885
3 Volumes Clients: 1637 - Véhicules: 1638 1637 1638
4 Volumes Clients: 17513 - Véhicules: 17689 17513 17689
5 Volumes Clients: 172004 - Véhicules: 173657 172004 173657 |
Partager