ThatJeffSmith

Tag: View

Finding Calculated View Columns

Imagine you have 300 or so views, and within those views, are a bunch of business rules. Like, we’re going to calculate someone’s salary as their salary + their (commission percent * sales). Now imagine your views, and their columns, aren’t documented. They’re not documented in the data model, and they’re not documented via the [...]

How to View Errors for VIEWs in Oracle SQL Developer

I know, who has errors in their code? I don’t have errors because I don’t write code. But for the rest of you, it’s possible you have inherited someone else’s problem. And that problem might be an invalid VIEW. You can tell your view has a problem because of the big, sad, red X Oracle [...]

Enterprise Doesn’t Mean What You Think It Does

One of the most dangerous phrases to be uttered in an organization is ‘Oh, we have an Enterprise license.’ Once that gets out, everyone will think they can deploy/use as much as product X as they want. It does not take much of an imagination to realize where this can lead. Standard VS Enterprise VS [...]

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