4.2 Tweak, Working with Views

thatjeffsmith SQL Developer 16 Comments

Someone said we should make the view source searchable, and that we should show any errors on a view. Actually, it might have been a few dozen of you. A reader reminded me that we actually implemented this in v4.2. Code Outline I’ll go into more depth here next week when I’m back from Open World, but we’re working on …

‘Modeling’ View Dependencies in SQL Developer Data Modeler

thatjeffsmith SQL Developer 4 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, …

Finding Calculated View Columns

thatjeffsmith SQL Developer 0 Comments

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 column comments. Now imagine someone …

Preserving Privilege Grants Whilst Editing Views in Oracle SQL Developer

thatjeffsmith SQL Developer 5 Comments

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 all. Let’s drill into this …