ThatJeffSmith

Category: SQL Developer

Dimensional Modeling in Oracle SQL Developer Data Modeler

Oracle SQL Developer Data Modeler (SDDM) is a free data modeling solution. It supports many types of modeling levels, including: logical relational physical (multi-)dimensional When I present overviews on our database tools, I have this slide that shows what SDDM is capable of: I am not a real data modeler. However, I can fake my […]

Oracle SQL Developer 4 and the Oracle Client

You don’t need to have an Oracle Client installed on your machine to use Oracle SQL Developer. Everything you need to connect to Oracle Database is provided by the JDBC driver included with the download. So you can be up and running in usually less than 5 minutes. But if you DO happen to have […]

The Best of 2013 SQL Developer Posts

There are many hundreds of interesting blogs in the Oracle Database space to choose from. I’m happy to say that about 300,000 of you spent at least a couple of minutes on my blog in 2013. In case you didn’t have a chance to read all 105 or so new posts, I’ll share with you […]

How to Change the UI Font Size for Oracle SQL Developer

Today’s Question: Are the Tree View fonts configurable? (E.g., Connections). I am using a high-resolution display (1920×1200) and they appear quite small. And the answer: Yes! Oh, but you probably wanted the how as well…OK. Here’s what the tree UI looks like out of the box on Windows 7, locale US English, with 1600×900 screen […]

Oracle SQL Developer 4: Windows and the JDK

A few things have changed when it comes to running SQL Developer on a Windows machine. In previous versions, the first thing you’d see when running SQL Developer would be a prompt asking for the location of Java. Turns out, it’s hard for Java applications to run without Java. On Macs and Linux/Unix environments, we […]

Oracle SQL Developer Data Modeler v4.0 Is Now Available

The title says it all. Version 4 is now available, replacing v3.3 as the current version. What you need to know: Downloads New Features Release Notes Docs My Two Favorite New Features Comment Only Views If you need to publish or produce a diagram for less technical users, with just an overview of entities or […]

Oracle SQL Developer Data Modeler 4 User Interface Improvements

The name probably gives it away, but just in case you weren’t aware of this, Oracle SQL Developer Data Modeler is an extension of Oracle SQL Developer. They share a framework that is derived from JDeveloper. The latest framework has some new user interface widgets that were adopted directly from Netbeans. I’ve blogged a bit […]

Oracle SQL Developer and Database Auditing

Did you know Oracle SQL Developer allows you to configure Database Auditing and view your audit trails? Well, now you do! This is not new for version 4.0, but the screenshots in this post are from version 4.0. This feature is available under the DBA panel, which can be found on the View menu. I […]

Defaults for Exporting Data in Oracle SQL Developer

I was testing a reported bug in SQL Developer today – so the bug I was looking for wasn’t there (YES!) but I found a different one (NO!) – and I was getting frustrated by having to check the same boxes over and over again. What I wanted was INSERT STATEMENTS to the CLIPBOARD. I’m […]

SQL Developer Q&A from ODTUG Tips & Tricks Webcast

Another great webcast yesterday – if you’re a paying member of ODTUG you can watch the show for yourself in their archives. If not, you can get my slide deck off of SlideShare. About 150 of you brave souls sat through an entire hour of me talking and then 10 more minutes of Q&A. We […]