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 [...]
sqldev
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 [...]
Configuring Display of Model Relationships in Oracle SQL Developer Data Modeler
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 [...]
Managing Storage Properties for Multiple Tables in Oracle SQL Developer Data Modeler
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 [...]
How to Hide Schema Notation from Tables in Oracle SQL Developer Data Modeler
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 [...]
Twitter
RSS
GooglePlus
Facebook