je voudrais savoir comment activer les fonctions analytiques ??????????????????????????????????
Voici le message qui s'affiche
Code:
1 select TO_CHAR(AT_DATE,'DD/MM/YYYY'),
2 SUM(distinct card_no) over(partition by TO_CHAR(AT_DATE,'DD/MM/YYYY') order by TO_CHAR
3* from CARD_TRANSACTIONS
SQL> /
select TO_CHAR(AT_DATE,'DD/MM/YYYY'),
*
ERROR at line 1:
ORA-00439: feature not enabled: OLAP Window Functions
Encore merci
Partager