ThatJeffSmith

Oracle SQL Developer Data Modeler 4 and Comment Display

A new feature in Oracle SQL Developer Data Modeler is the ability to display table and view comments directly in the ERD. So I can go from this:

Normal Relational Diagram

What you're used to seeing

What you’re used to seeing

to

Relational Diagram with Comments

Same as before but with comments now too

Same as before but with comments now too

to

Relational Diagram with Comments ONLY

Just the comments ma'am, just the comments

Just the comments ma’am, just the comments

Now the cool part is that I don’t have to pick. I can use all three depending on my need. Maybe I need a dev diagram for folks in the know, another diagram for biz users that need the built-in docs, and a 3rd higher level view that just explains the tables purpose.

We do this of course, with Displays.

Displays let me have multiple visual takes on a diagram

Displays let me have multiple visual takes on a diagram

And we configure what’s shown in a diagram by right-clicking in the diagram itself:

Use the 'Names only' to go spartan style...

Use the ‘Names only’ to go spartan style…

How can I find stuff with or without comments?

Maybe you want a report on the documented attributes, columns, entities, or tables in your model. It’s easy to find that, just do an advanced search and look where the value is NOT null.

Also a new feature in this version of the Modeler, doing NOT searches.

So show me tables where the comments aren’t blank:

show me everything basically

show me everything basically

And the results

search_null2

To do the opposite search, just toggle off the ‘Not’ flag in the search parameters.