Tuesday, March 26, 2019

Oracle: Get Month Start and End Dates for a Given Period

Hassan Saleem (Oracle Apps Technical) March 26, 2019 Leave a Reply
    SELECT   TRUNC (ADD_MONTHS ('01-JAN-19', LEVEL - 1), 'MM') start_date,
             LAST_DAY (ADD_MONTHS ('01-JAN-19', LEVEL - 1)) end_date
      FROM   DUAL
CONNECT BY   LEVEL <= CEIL (MONTHS_BETWEEN ('30-JUN-19', '01-JAN-19'))
Tags:
Previous Post
Next Post
Hassan Saleem (Oracle Apps Technical)

Overall 5+ Years Hands-on Experience in RICE COMPONENTS i.e. Reports, Interfaces, Conversions and Enhancements of screens/reports (using Oracle FORMS/Oracle REPORT/ XML Publisher) for standard and customize Oracle Applications. Write, debug, database packages, procedures/Function/Triggers in RDBMS using Oracle Technologies i.e. (SQL, PL/SQL) as per business requirement with SQL/PLSQL Tuning, Code Review, Testing, Training and providing Technical support to Clients.

0 comments: