Oracle PL/SQL

Monday, September 04, 2006

Display Month names from JAN to DEC

How to display the names of Months from JAN to DEC ? This is a beautiful query that I found in Forums :-

SELECT
NUM,
to_char( to_date(NUM,'mm'),'MON','nls_date_language=american') MONTH
FROM
(
SELECT level NUM from dual connect by level <= 12);

0 Comments:

Post a Comment

<< Home