How to Create or Open a Data Model in Oracle SQL Developer

thatjeffsmith SQL Developer 6 Comments

The Oracle SQL Developer family currently has two ‘SQL Developer’ branded products: Oracle SQL Developer Oracle SQL Developer Data Modeler Oracle SQL Developer is the database IDE and Oracle SQL Developer Data Modeler is our dedicated data modeling solution. Where it gets interesting is that the entire Data Modeler product also runs inside of SQL Developer. When I do demo’s …

Managing Table and Column Comments in Oracle SQL Developer

thatjeffsmith SQL Developer 12 Comments

An interesting question came up on the ORACLE-L mailing list this morning regarding table comments: Just wanted to get a general opinion on using comments in the database. For example COMMENT ON COLUMN table.column “No comment”. Does anyone do this as a regular best practice? I would prefer to see this abstraction in a data model, maybe not pushed to …

Oracle SQL Developer Data Modeler Primer: Navigating Designs, Models, and Diagrams

thatjeffsmith SQL Developer 15 Comments

It’s worth a few moments to get your bearings when using a new program. Or maybe you’ve been using SQL Developer Data Modeler for awhile now, and just haven’t taken the time to understand how designs, models, and diagrams are handled. This short post will fill in a few gaps and increase your comfort level with the tool, so please …

Synching your Oracle SQL Developer Data Model with the Database

thatjeffsmith SQL Developer 27 Comments

So you’ve been working on your data model, and you’re wondering how far ‘out of whack’ it is with the production or development database instance. Sometimes folks manage to compile changes into the database, bypassing your design process and rules. If you’re wondering how to compare 2 models instead of your model with the database, read this. So your question …

Configuring Display of Model Relationships in Oracle SQL Developer Data Modeler

thatjeffsmith SQL Developer 36 Comments

The end goal for many users of Oracle SQL Developer Data Modeler is a a nicely formatted, easy to read diagram. Diagrams are composed of two primary components: Tables or Entities Relationships Today’s post is all about how to manage the display of the relationships. How can I move the lines around? You might not like the default anchor point …

Managing Storage Properties for Multiple Tables in Oracle SQL Developer Data Modeler

thatjeffsmith SQL Developer 3 Comments

There were more than a few questions I didn’t get a chance to answer in last week’s webcast with @ODTUG, ‘Data Modeling 101 with Oracle SQL Developer.’ If you’re a member of ODTUG, then you can watch or download the webcast. If you’re NOT a member, you can still sign up to attend KSCOPE13 in New Orleans and watch my …

How to Hide Schema Notation from Tables in Oracle SQL Developer Data Modeler

thatjeffsmith SQL Developer 5 Comments

Today’s question: Argh ! How can I remove the schema name from the relational diagram for a table in Sql Data Modeler ? Let’s take a quick look at the user’s source of frustration. I’ve previously reverse-engineered several Oracle schemas into a relational model in Oracle SQL Developer. HR and two other HR-Cloned users containing about 90 tables. Our user …

Exporting Table Column Comments to Excel using Oracle SQL Developer Data Modeler

thatjeffsmith SQL Developer 12 Comments

I love it when I get product and technology questions from our users. More often than not, it leads to me citing a blog post on the subject, or even better, inspires new writing material. And that’s the case for today’s post: Is there an easy way to fake the search tool into getting all the tables in a design …

SQL Developer Data Modeler v3.3 Early Adopter: Link Model Objects Across Designs

thatjeffsmith SQL Developer 5 Comments

The third post in our “What’s New in SQL Developer Data Modeler v3.3” series, SQL Developer Data Modeler now allows you to link objects across models. If you need to catch up on the earlier posts, here are the first two: New and Improved Search Collaborative Design via Excel Today’s post is a very simple and straightforward discussion on how …