SQL query in OBIEE SQL prompt error

User_Y2R87

Hi,

I tried last 12 months in YYYYMM format as a SQL query result in OBIEE sql prompt. but its throwing error.

Select TO_CHAR( ADD_MONTHS( TRUNC(SYSDATE,'year') , LEVEL-4 ), 'YYYYMM' ) Month
FROM dual
CONNECT BY LEVEL <= 12
;

below is this scenario i'm trying to attain

Raghavan p-Oracle

Hi @User_Y2R87,

Try below:

===

Select TO_CHAR( ADD_MONTHS( TRUNC(SYSDATE,'YYYY') , LEVEL-4 ), 'YYYYMM' ) Month
FROM dual
CONNECT BY LEVEL <= 12

====

Best Regards,

Raghavan