‘Modeling’ View Dependencies in SQL Developer Data Modeler

thatjeffsmith SQL Developer 8 Comments

Today’s question: Please let me know how can I represent relation between view and base table in ER diagram created using sql datamodeler version4. So I know what the person is getting at here. They want to see the dependencies. Generally speaking, there are no actual relations between views and tables. Exception: you CAN define foreign key constraints on VIEWS, …

How to find dependent objects in your PL/SQL Programs using SQL Developer

thatjeffsmith SQL Developer 9 Comments

I’ve answered this question a few times over the past several months, but I’m just now getting around to putting my answer onto ‘paper.’ The common scenario is someone decides to alter a table. Immediately the paranoid – is it really paranoia if someone is actually out to get you? – start to worry about how many programs they’ve just …