tinman spent a few years mucking around industry before going back to school for a Masters. Currently not enjoying the weather in North England..
He wrote Perl that looked suspiciously like C code in 1998, while working as an intern, and has been trying to cure that bad habit ever since.
Sigh...find myself without any officially assigned work for the moment, so dug out an old Oracle schema dumping script, and decided to rewrite.. Ouch..but even code that was written a few months ago seems to be very longwinded and simplistic now.. not elegant at all, so this is the time to rewrite, I feel..
Its pretty Oracle specific, and uses the dictionary views to dump a complete description of the database in XML form, tables, views, sequences, materialized views, the whole nine yards... I just needed it to get all the stored procedures and packages out of the database in a compile ready form.. somehow it also mutated into a DB diff tool..
Why am I not using DDL::Oracle, I ask myself for only about the 100th time, mostly because this sorta seems cooler to me (buzzword warning: this dumps stuff in XML *grin*)..at least I know about DBI placeholders now, thanks to Perlmonks, and so I'm seeing a HUGE reduction in the number of prepare statements already...
Hopefully I can post it in PM.. haven't posted in ages, it seems..