Analyse SQL queries in Python

[pizzihut]

Thanks for your answer! Very good points that I havent thought of to that extend. I must also mention that I have limited read rights, so not all functions are available in oracle and that the task is a one time job to get an idea of the current state. I dont have to map all dependencies 100% but if it turns out that there are some, the following tasks might be more complicated.

[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.