ThatJeffSmith

Category: SQL Developer

Oracle SQL Developer and Java 7

The current version of Oracle SQL Developer requires at least Java 6, e.g. the 1.6 JDK. I talk about Java, JDKs, JREs and what all that means in a previous post if you need to catch up on the lingo. Many versions of Java out there – 5, 6, and 7 are the most common. […]

SQL Developer: I’m Looking at a Record, How Do I Edit It?

You’re doing some data clean-up, or maybe you’re just trying to answer a business question for a user, and you notice the data doesn’t look quite right. You want to click in that ‘(null)’ cell and tell the world that Tyler and Perry composed that song! But, we’re in a query result set, and not […]

Querying Your Oracle SQL Developer Data Modeler Designs

Oracle SQL Developer Data Modeler has a multi-user repository that makes it very easy to control and version changes to your data models and designs. However, it’s stored in a Subversion (think files) repository. Many of our users are accustomed to having EVERYTHING stored in the database. And when something is in a database, then […]

Monitoring Scripts as They Execute in Oracle SQL Developer

Interesting question from the forums: I’m doing multiple Inserts on a table using a script file (.sql) in SQL Developer. Since it has a lot of statements, I would like to check the progress of it somewhere in the application window. But I don’t see any progress of lines being displayed anywhere. The focus simply […]

Ever Run a Truncate, Drop, or Delete in the Wrong Database?

Hurts, doesn’t it? And tools make it so easy to do this. Even though your tool probably reminds you where you’re at, your brain often just starts running after the next task. And usually your fingers are even a few steps ahead of your brain. And then you get into trouble. All because you’re trying […]

Die! Or How to Cancel Queries in Oracle SQL Developer

I’m not sure why, but it appears many of you wish you could take back your SQL queries. It’s like that one time you posted that picture on Facebook and immediately (3 days later) you realized it wasn’t a great career move. Maybe that data you asked for wasn’t going to be that helpful if […]