Saturday, May 28, 2022

4 fiscal quarters in oracle sql

 SELECT to_char( add_months( '&report_date_', 7 ), 'YYYY' ) fiscal_year,

       'Q'||to_char( add_months( '&report_date_', 7 ), 'Q' ) fiscal_quarter

  FROM dual;

No comments:

Post a Comment

How to install and configure Oracle Apex 24.1 with ORDS 22, Tomcat 9 and Jasper Report 7 on Oracle Linux 8.10

#########################Install Oracle  APEX 24.1################################ ----------------------------------------------------...