1 2 3 4 5 6 7 8 9 10 11 12 13 14
| with table1 as (
select 1 as col1, 1 as col2, 1 as col3, 150 as col4 from dual union all
select 1 as col1, 2 as col2, 1 as col3, 250 as col4 from dual union all
select 1 as col1, 3 as col2, 1 as col3, 350 as col4 from dual union all
select 1 as col1, 4 as col2, 1 as col3, 450 as col4 from dual union all
select 1 as col1, 5 as col2, 1 as col3, 550 as col4 from dual union all
select 1 as col1, 6 as col2, 1 as col3, 650 as col4 from dual),
table2 as (
select 1 as col1, 100 as borneinf, 199 as bornesup from dual union all
select 2 as col1, 100 as borneinf, 199 as bornesup from dual union all
select 3 as col1, 200 as borneinf, 299 as bornesup from dual union all
select 4 as col1, 300 as borneinf, 499 as bornesup from dual union all
select 5 as col1, 300 as borneinf, 499 as bornesup from dual union all
select 6 as col1, 500 as borneinf, 599 as bornesup from dual) |
Partager