Tag: View

‘Modeling’ View Dependencies in SQL Developer Data Modeler

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

Similar Posts by Subject Areas: , , , , ,

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

Similar Posts by Subject Areas: , ,

Preserving Privilege Grants Whilst Editing Views in Oracle SQL Developer

Today’s Question: How do we prevent Oracle SQL Developer from dropping the grants/privileges when modifying a view. While using SQL Developer we modified a view and once saved it removed all of the user access previously set up for the view. This did not previously take place when using… Ugh. That doesn’t sound good at […]

Similar Posts by Subject Areas: , , ,

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

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,