Binary to Dec and reverse

[martindsouza]

See http://www.orafaq.com/wiki/Binary

For dec2bin should also include option to add spacing.

Can also look at passing in base as an option to expand logic to hex etc.

[zhudock]

Tom Kyte has a decent example of converting decimal to any base up to base36. His PL/SQL is pretty lightweight.
http://www.oracle.com/technetwork/issue-archive/2006/06-jul/o46asktom-085866.html