René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Oracle SQL Shorties

Converting numbers to strings:

select to_char(to_date(112004,'J'), 'JSP') from dual;
Note, the largest value that can be converted is 1721057.