ORACLE / Jointure Externe et SQL*Plus
1 2 3 4 5 6 7 8
| select * from chrono;
ID DATE_C BLA_BLA
---------- -------- ----------
1 16/08/05 Bla1
2 16/08/05 Bla2
3 16/08/05 Bla3
4 16/08/05 Bla4 |
1 2 3 4 5 6 7 8
| select * from chrono_production;
ID DATE_C TYPE_PROD
---------- -------- ----------
1 16/08/05 T1
1 16/08/05 T2
3 16/08/05 T3
4 16/08/05 T1 |
break on id on date_c on report
1 2 3 4 5 6 7 8 9 10 11 12 13
| Select C.id,C.date_C,P.type_prod
from chrono C,chrono_production P
Where C.id = P.id(+)
And C.date_C = P.date_C(+);
ID DATE_C TYPE_PROD
---------- -------- ----------
1 16/08/05 T1
T2
2 16/08/05
3 16/08/05 T3
4 16/08/05 T1 |
Partager