ThatJeffSmith

Tag: sqldev

Introducing the OTN Developer Day Database 12c VirtualBox Image

If you’re looking for an already configured Oracle Database 12c environment with a database already setup and all the software you need to learn database programming, design, and administration concepts, then look no further: This Stuff is all FREE The virtualization software is VirtualBox – that’s free. And it runs on any OS, including Windows, […]

How to Open the Data Modeler in Oracle SQL Developer

You are using Oracle SQL Developer, and you want to create or open a design in the Data Modeler. How do you GET to the Modeler? Oracle SQL Developer Data Modeler is a standalone solution that is also shipped in SQL Developer as an extension. The user interface of the Modeler is folded into SQL […]

Oracle SQL Developer for the DBA

Wait, I thought SQL Developer was for developers? Yes, but it also provides a ton of features and value for the DBA. So if you’re already in SQL Developer to browse a table or run a query, you can fire up the DBA features under the View menu (and maybe save yourself an alt-tab to […]

Defining 12c IDENTITY Columns in Oracle SQL Developer Data Modeler

You’re excited to see that defining triggers and sequences to populate identity columns in Oracle Database is no longer required. You have an Oracle Database 12c instance up and running, and you’re ready to hit the ground running. Wait, what is Jeff talking about? Ok, let’s say I have a ‘BEER’ table. My Primary Key […]

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 […]

Oracle SQL Developer: Potpourri and Random Thoughts

2013 has been a big year for us here at Oracle and in the tools group. We saw major updates for both SQL Developer and SQL Developer Data Modeler. For the data modeler, versions 3.3 and 4.0 brought significant feature and platform updates. Both are still free by the way I’m still very, very high […]

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 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 […]