Month: June 2012

Display four digit year as tax financial academic year

This SQL works for all years from AD 9 onwards: SELECT ‘2011’ , ‘2011’ || ‘/’ || SUBSTR ( 1 + TO_NUMBER ( ‘2011’ ) , -2 ) formatted FROM DUAL ; Results: ‘201 Formatted —- ——— 2011 2011/12

Posted in Uncategorized

Oracle User Group Scotland Conference 2012

My notes from the 2012 Oracle User Group Scotland Conference:

Posted in Uncategorized