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 [...]

No comments:

Post a Comment

Thank's!