ThatJeffSmith

SQL Developer 4.1: Easier Excel Imports

The most read post on this site? ‘How to Import from Excel to Oracle with SQL Developer‘ – and it has been since I published it almost 3 years ago. People really like Excel. Or I should put it this way – Excel is the way information is shared in an organization. It makes no […]

SQL Developer 4.1: Multi-Cursor Editing

‘Make the editor work like Sublime Text or Crimson!’ So goes the several dozen requests I get each year. Well, in version 4.1, we’ve got something I think you’ll like. It’s a bit different than column text edit modes – but it allows for the same idea, and it’s even more powerful…I think. You can […]

SQL Developer 4.1 – Log All the Queries!

Oracle SQL Developer is a graphical user interface and integrated development environment for Oracle Database. As you can imagine, a few clicks can results in an awful lot of queries being executed on your behalf. If you don’t like this fact, you can always use a command-line interface like SQL*Plus or the new sdsql. The […]

Java 8 on a Mac with SQL Developer 4.1

I ran into a few dramas getting SQL Developer 4.1 on my MacBook Air going earlier today. It boiled down to convincing SQL Developer to find and use the proper JDK on OS X Yosemite. So just in case it’s not me out there, here’s what I had to do. Unless you already have Java […]

SQL Developer 4.1 – Instance Viewer

The SQL Developer team has been steadily adding features tailored to the DBA since the version 3.0 release. This steady march continues with version 4.1, which was released as an Early Adopter yesterday. The DBA feature I want to talk about today is the Instance Viewer. Well, technically the window is labled as the ‘DB […]

SQL Developer Formatter: Left Aligning Columns in a SELECT

Question: I can’t figure out how to make a column list align like this (underscore = space): _SELECT_column1 ______,_column2 ______,_column3 ______,_column4 ___FROM_table The closest result that the formatter produces is: _SELECT_column1, __column2, __column3, __column4 ___FROM table where all column names start at text position 3… My answer isn’t going to be perfect, but it’s going […]

Quick Tip: Controlling how PL/SQL Errors are Shown

Remember, you only see the error messages in the log AFTER a compile. If you want to see the list of errors at any time, simply click on the ‘Errors’ page, or try compiling your program again. While we’re on this page, there’s lots and lots of cool things you can fiddle with here. For […]

Working with PL/SQL in Oracle SQL Developer

Oracle SQL Developer is a tool. My general rule for using tools boils down to – if the tool is making it harder to do the job you’re using it for, you’re either ‘doing it wrong’ or you have the wrong tool. Sorry for the long setup, but I had someone approach me at the […]

A Quick Tip on Finding Data in Oracle SQL Developer

Looking at endless spreadsheets or grids of data can make one’s brain a bit fuzzy. SQL Developer makes it easy to spot the bad data you’re looking for. Hit Ctrl+F in a grid. Type your search term. If you’re going to be looking for this data going forward, check the ‘Persist Highlight’ box. So for […]

SQL Editor Code Templates: A Must-Know Trick

Oracle Docs just underwent a facelift, and I was testing to make sure that the code insight feature in SQL Developer was still able to pick out our code samples. Good news, it still works! But, I was getting distracted by a bit of code that LOOKED like it was DOCS related, yet wasn’t… So […]

Setting Up Oracle SQL Developer on a Mac

My work machine is a Dell laptop running Windows 7. My home machine is a MacBook Air running OS X Yosemite. 98% (made up number) of the posts on this site were written using my Windows machine. But now that I’ve discovered that my SnagIt license is also valid on my Mac, I’m trying to […]