Monitoring Scripts as They Execute in Oracle SQL Developer

thatjeffsmith SQL Developer 2 Comments

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 stays on in the first …

A SQL Developer Primer: Open a New Worksheet

thatjeffsmith SQL Developer 5 Comments

The Worksheet in Oracle SQL Developer is your primary interface for writing and running your SQL and PL/SQL code. As you can imagine, I’ve already written quite a bit about how the worksheet ‘works’. Today I want to spend just a few moments explaining the two different buttons for launching a new worksheet. With a worksheet open and active, you’ll …

SQL Developer: Why Do You Require Semicolons When Executing SQL in the Worksheet?

thatjeffsmith SQL Developer 8 Comments

There are many database tools out there that support Oracle database. Oracle SQL Developer just happens to be the one that is produced and shipped by the same folks that bring you the database product. Several other 3rd party tools out there allow you to have a collection of SQL statements in their editor and execute them without requiring a …

Formatting Keywords to UPPERCASE In Oracle SQL Developer

thatjeffsmith SQL Developer 28 Comments

I received this question from a customer today, and it took me more than a few minutes to remember where this preference was located in SQL Developer. This tells me that the topic is ripe for blogging 🙂 How do I go FROM: SELECT * FROM scott.emp WHERE ename LIKE ‘%JEFF%’ TO SELECT * FROM scott.emp WHERE ename LIKE ‘%JEFF%’ …

Oracle SQL Developer v3.2 is Now Available!

thatjeffsmith Expired 19 Comments

Today we released the latest version of Oracle SQL Developer – v3.2.09.23. The official resources: SQL Developer on Oracle Technology Network (OTN) Release Notes New Features SQL Developer Forum I’ll showcase a few of my favorite new features and tweaks in the next several days and weeks, but I thought I’d kick things off right now with a new ‘trick!’ …