ThatJeffSmith

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

Oracle SQL Developer Look and Feels

SQL Developer is a Java Swing desktop application – surprise! We support a native operating system ‘look and feel‘ and also ship with an Oracle look and feel (LnF). The architecture of Swing is designed so that you may change the “look and feel” (L&F) of your application’s GUI (see A Swing Architecture Overview). “Look” […]

Oracle SQL Developer Code Reports

It’s so much more fun to watch users demo and brag about your software than it is to get up and do it yourself. For one thing, it means a lot more coming from real people than it does coming from someone PAID to talk it up. Today, about 40 of us in Raleigh/Durham watched […]

Explain Plan ‘Notes’ in Oracle SQL Developer

Oracle ACE Director, BI/data/all things cool and extraordinaire, Stewart Bryson had a bit of a complaint about our favorite tool today. He wants Explain Plans in SQL Developer to show the same notes you can see in SQL*Plus… @thatjeffsmith See… no execution… and the notes. With one little statement. pic.twitter.com/w3GYkIPaDY — Stewart Bryson (@stewartbryson) November […]

Videos: Oracle Open World 2014 SQL Developer Talks

For this year’s Open World, SQL Developer got lots and lots of love from the conference organizers and keynote speakers. I think SQL Devleoper was mentioned, demoed, or both in at least 3 of the executive keynotes. We had many successful, and FULL, hands on labs – led by the lovely Ashley Chen. And our […]

Modeling Function Based Indexes in Oracle

@thatjeffsmith Is there a way to define a function-based index in #SQLDevModeler? — Kent Graziano (@KentGraziano) October 29, 2014 Function based indexes [DOCS] have been part of Oracle Database since at least version 8. Instead of just indexing someone’s name, you could also index the values returned by a function call over that name. Example […]

Spelling is Hard, esp SYNONYMS

I don’t think the word synonym is especially hard to spell, I just think it’s hard for my fingers to type it correctly. I’ve incorrectly typed it often enough that muscle memory is working against me. I run into a lot of developers that never learned to type, which sounds weird to me – like […]

Data Modeling via Excel?

In SQL Developer if you use the Import Data feature from the main tree node, it will create a new table based on a delimited text or Excel file. We’ll look at the data and create some columns for you. In version 4.1, we’ll recognize numbers as numbers, dates as dates, and try to get […]

How Do I Switch Tools and Start Using SQL Developer?

So you have decided to give Oracle SQL Developer a try. You’ve been working with Oracle for 15+ years, and you’re a bit set in your ways. But not THAT set in your ways. Want some advice for getting started in SQL Developer? Here goes… Go cold turkey. Put down your other tool(s). Pick up […]