Tuesday, April 3, 2012
Use SQL to Create a Calendar in Mutliple Languages
Use SQL to Create a Calendar in Mutliple Languages: In his post titled learning foreign languages with Oracle SQL, Matthias Rogel shares the following query (I slightly modified and formatted it for clarity): WITH calendar AS ( SELECT ADD_MONTHS (DATE '2012-01-01', LEVEL - 1) mon_date ,TO_CHAR (ADD_MONTHS (DATE '2012-01-01', LEVEL - 1), 'Month') mon_name FROM DUAL CONNECT BY LEVEL <= 12) SELECT nls.VALUE AS [...]
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Thank's!