1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
|
SQL> select * from t1;
ID_SPECIF ID_OPERATION ID_SEQUENCE ID_PARAMETRE VALEUR
---------- ------------ ----------- -------------------------------------------------- ----------
1 100 10 para1 20
1 100 10 para2 10
1 100 10 para3 30
1 520 20 para1 40
1 520 20 para3 20
SQL> SELECT DISTINCT id_specif, id_operation, id_sequence,
2 SUM (DECODE (id_parametre, 'para1', valeur, NULL)) OVER (PARTITION BY id_specif
, id_operation)
3 param1,
4 SUM (DECODE (id_parametre, 'para2', valeur, NULL)) OVER (PARTITION BY id_specif
, id_operation)
5 param2,
6 SUM (DECODE (id_parametre, 'para3', valeur, NULL)) OVER (PARTITION BY id_specif
, id_operation)
7 param3
8 FROM t1;
ID_SPECIF ID_OPERATION ID_SEQUENCE PARAM1 PARAM2 PARAM3
---------- ------------ ----------- ---------- ---------- ----------
1 100 10 20 10 30
1 520 20 40 20
SQL> |
Partager