SQL query in OBIEE SQL prompt error

Question

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 · Answer

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