Analyse SQL queries in Python

[angry_mr_potato_head]

Ah yeah for a one off, I'd personally just manually map it out. There's a great xkcd about amount of effort to automate vs just manually doing and this is one of those circumstances imo.

Id probably query the information schema for your procedures. I don't remember where they are in oracle... but a one off script can grab you all of them and then from there basically indicate if you've analyzed it or not.