I have a nasty habit of not thinking. I take something for granted or assume something for so long, that it corrupts my original learning or understanding of a concept. And then when someone calls me out, my first reaction is to defend my ‘shortcut’ thinking instead of re-evaluating my set of assumptions. So I’ve [...]
ERD
SQL Developer Data Modeler Quick Tip: Use SubViews
Modeling is cute when you’re in a class and the sample application is for a rotisserie league for fantasy football, or you need a shopping cart ordering system for online retail. You spend a few hours and might come up with several dozen tables. But what about in the real world when you are trying [...]
Reverse Engineer Views into an ERD
ERD – Fancy way of saying Entity-Relationship Diagram Since version 10.0 of Toad for Oracle, users have been able to select a table and have an ERD generated that automatically includes any related tables via Referential Integrity. However, what if you are trying to document a view which may bring in one or more other [...]
Twitter
RSS
GooglePlus
Facebook