…to Create Alternate Visual Presentations of your Diagrams Your data model tells a story, and we all learn as small children that the best stories have pictures – the more the better! There’s a reason I try to always have at least one picture in my blog posts – even adults are easily distracted. We [...]
Oracle SQL Developer Data Modeler Primer: Navigating Designs, Models, and Diagrams
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 [...]
Synching your Oracle SQL Developer Data Model with the Database
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, [...]
How to Plug vi into Oracle SQL Developer
Love vi? Prefer emacs? Want the power of the 80′s added to Oracle SQL Developer? You can do that via our External Tools feature. And you can even have SQL Developer throw over your open file into vi, edit it, save it, and refresh the buffer in the worksheet to reflect the file changes. Here’s [...]
How to Copy Only Column Headers from Query Results in Oracle SQL Developer
Short and sweet post today – let’s say you’ve written a SELECT *, and your query results have some column headers you want to copy out. Yes, you could copy out the result set WITH the column headers, but maybe you JUST want the column names themselves. Note you need to select which column headers [...]
Twitter
RSS
GooglePlus
Facebook