ThatJeffSmith

Tag: tips

SQL Developer Q&A from ODTUG Tips & Tricks Webcast

Another great webcast yesterday – if you’re a paying member of ODTUG you can watch the show for yourself in their archives. If not, you can get my slide deck off of SlideShare. About 150 of you brave souls sat through an entire hour of me talking and then 10 more minutes of Q&A. We […]

Keyboard Shortcuts in Oracle SQL Developer

What keyboard shortcuts should EVERY Oracle SQL Developer user know? How do you find new shortcuts to master, and how do you change them to match ones you’ve already learned in other tools? These are the driving questions for today’s post. While some of us may be keyboard ninjas, and others are more driven to […]

Running & Managing Concurrent Queries in SQL Developer

We’ve all been there – you’ve managed to write a query that takes longer than a few seconds to execute. Tuning aside, sometimes it takes longer than you want for a query to run. So what’s a SQL Developer user to do? I say, keep going! While you’re waiting for your query to finish, there’s […]

‘Forcing’ Line Breaks in Oracle SQL Developer

Oracle SQL Developer is at its heart, an Interactive Development Environment (IDE.) So it comes with the territory that developers should expect to be able to write good code quickly. One of the many code ‘helpers’ that a good IDE will provide is a Formatter. Formatters, or code beautifiers as they’re also known, take poorly […]

I Say Snippet, Snippet Good: SQL Developer Snippets

There’s nothing worse than the ‘white screen of panic.’ You’re faced with the prospect of actually writing some code from scratch. Or even worse, you’re doing a presentation or demo, and everyone gets to see what a horrible typist you are. Yes, you could browse your SQL History, but that could contain several hundred or […]

Auto-Generate Group By Clauses with Oracle SQL Developer

This feature is sure to define your placement into one of the following camps: I love it when my IDE helps me with my code I hate it when my IDE inserts code I didn’t explicitly type And the feature is – Autogenerate Group By clause The help defines this preference/feature as: Automatically generates a […]

How To Block Select Text in Oracle SQL Developer

This drove me nuts for a few minutes, so I figure you might need help too. That probably explains why you had to Google ‘Block Select’ and wound up here. Here is what you want: There’s No Trick, But You Do Have to Enable It The default behavior is to do a normal ‘wrapping’ selection […]

Top 10 Tips & Tricks for Oracle SQL Developer

Being a short week due to the holiday, and with everyone enjoying their Summer vacations (apologies Southern Hemispherians), I reckoned it was a great time to do one of those lazy recap-Top 10-Reader’s Digest type posts. I’ve been sharing 1-3 tips or ‘tricks’ a week since I started blogging about SQL Developer, and I have […]

Oracle SQL Developer Tips & Tricks Presentation

Updated: June 16, 2014 I’ve been giving this presentation for about 3 years now. It’s morphed, mutated, and improved incrementally for that entire time. I say I have a ‘top 10′ but it’s closer to 15 or so. It’s a VERY interactive session, with live demo. And there’s always lots of questions as we go. […]

SQL Developer Video Tutorial: Navigating Your PL/SQL

If a picture is worth a 1,000 words, how valuable is a 6 minute video? Instead of throwing up a bunch of bullet points and screenshots on the blog, I’m going to let you watch the movie instead. In just a few minutes, learn how to maximize your SQL Developer experience by Navigating the connection […]

SQL Developer Query & Grid Tricks

It helps to know the developers. They can tell you things that are not documented in the help or release notes. They mostly don’t hide things on purpose, mostly. They often build things into the application to aid themselves, but usually it’s for the end user’s benefit. @krisrice sent me over a few nuggets to […]

SQL Developer Trick: DropDown Vs Tree

I’m not saying there’s anything wrong per se with SQL Developer’s tree control for navigating your connection objects. As a matter of fact there are a few things to really admire about the tree implementation. Just in case you have NO IDEA what I’m talking about, here is the tree in all its glory. Scrolling […]

SQL Developer Data Modeler Quick Tip: Preferred Data Types

There are many data types to choose from when defining your table columns. The eighty percent rule tells us we can probably get away with a smaller subset of data types eighty percent of the time. Here is what the ‘TYPE’ control looks like in the modeler when defining a column: I was curious to […]