1 2 3 4 5 6 7 8 9 10
| SQL> SELECT DISTINCT cen_benef,substr(DECODE(substr(CEN_BENEF,1,4),'0004','0000'||substr(CEN_BENEF,5,length(CEN_BENEF)),'000' || SUBSTR (cen_benef, 8, LENGTH (cen_benef))|| '0000'),1,9) subId_local,DECODE(substr(CEN_BENEF,1,4),'0004','0000'||substr(CEN_BENEF,5,length(CEN_BENEF)),'000' || SUBSTR (cen_benef, 8, LENGTH (cen_benef))|| '0000') int_ide_benef,cen_code_naf
2 FROM centralisations
3 WHERE cen_mois BETWEEN TO_DATE ('01/11/2007', 'DD/MM/YYYY')
4 AND TO_DATE ('01/12/2008','DD/MM/YYYY')
5 AND cen_indiv = 1
6 group by subId_local,int_ide_benef,cen_code_naf;
group by subId_local,int_ide_benef,cen_code_naf
*
ERREUR à la ligne 6 :
ORA-00904: "INT_IDE_BENEF": invalid identifier |
Partager