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