Month Range
-- Build Month Range as the month number (v_month_id) changes

SELECT
   v_month
  ,CASE WHEN (11 - v_month_id) >= 0 THEN 'JAN' ELSE NULL END JAN 
  ,CASE WHEN (10 - v_month_id) >= 0 THEN 'FEB' ELSE NULL END FEB 
  ,CASE WHEN (9  - v_month_id) >= 0 THEN 'MAR' ELSE NULL END MAR
  ,CASE WHEN (8  - v_month_id) >= 0 THEN 'APR' ELSE NULL END APR
  ,CASE WHEN (7  - v_month_id) >= 0 THEN 'MAY' ELSE NULL END MAY
  ,CASE WHEN (6  - v_month_id) >= 0 THEN 'JUN' ELSE NULL END JUN
  ,CASE WHEN (5  - v_month_id) >= 0 THEN 'JUL' ELSE NULL END JUL
  ,CASE WHEN (4  - v_month_id) >= 0 THEN 'AUG' ELSE NULL END AUG
  ,CASE WHEN (3  - v_month_id) >= 0 THEN 'SEP' ELSE NULL END SEP
  ,CASE WHEN (2  - v_month_id) >= 0 THEN 'OCT' ELSE NULL END OCT
  ,CASE WHEN (1  - v_month_id) >= 0 THEN 'NOV' ELSE NULL END NOV
  ,CASE WHEN (0  - v_month_id) >= 0 THEN 'DEC' ELSE NULL END DEC
FROM 
 (SELECT LEVEL-1 v_month_id
  FROM  DUAL
  CONNECT BY LEVEL <= 12
);

Month Range

Dual Table Queries    Calendar Query    SQL Functions

Top

Oracle registered trademark of Oracle Corporation.

Last Revised On: December 20th, 2013

  56236