ThatJeffSmith

Category: Database Stuff

Oracle SQL Developer and Viewing User TYPE Data

A ‘quick’ question came in this morning: “Jeff, does SQL Developer show contents of Object type columns? I’m advised not…” I wanted to say ‘Yes’ and then just run away laughing maniacally, but I thought maybe I should put together a quick example instead. So here goes. And by the way, welcome to 2013 everyone [...]

Oracle SQL Developer Book?

I’m frequently asked about books for SQL Developer. There are a few out there, with the most obvious example being from former Product Manager Sue Harper. I love books, and I’m a voracious reader. But books pose a few problems in the techie space: they are out of date the day they are printed they [...]

Top 10 Most Popular Oracle SQL Developer Posts of 2012

Yes, another ‘Top 10′ list is here! Yes, it’s lazy. But, I’m all about lazy, and just because it’s lazy and overdone, doesn’t mean it has no value. If you’re new here or if you have a hard time catching up with all of your favorite bloggers and news outlets, here are my most popular [...]

The Problem Should Define the Process, Not the Tool

I’m stepping down from my SQL Developer pulpit today and standing up on my philosophical soap box. I’m frequently asked to help folks transition from one set of database tools over to Oracle SQL Developer, which I’m MORE than happy to do. But, I’m not looking to simply change the way people interact with Oracle [...]

Formatting Keywords to UPPERCASE In Oracle SQL Developer

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: TO It’s all in the formatting You need to access the formatting preferences [...]

I have Oracle SQL Developer Installed, Now What?

If you’re here because you downloaded a copy of Oracle SQL Developer and now you need help connecting to a database, then you’re in the right place. I’ll show you what you need to get up and going so you can finish your homework, teach yourself Oracle database, or get ready for that job interview. [...]

Quick Outline: Navigating Your PL/SQL Packages in Oracle SQL Developer

If you’re browsing your packages using the Connections panel, you have a nice tree navigator to click around your packages and your variable, procedure, and functions. But What if you drill into your PL/SQL source from the worksheet and don’t have the Tree expanded? Let’s say you’re working on your script, something like – So [...]

Resetting Your Oracle User Password with SQL Developer

There’s nothing more annoying than having to email, call, or log a support ticket to have one of your accounts reset. This is no less annoying in the Oracle database. Those pesky security folks have determined that your password should only be valid for X days, and your time is up. Time to reset the [...]

SQL Developer Data Modeler v3.3 Early Adopter: Search

The next version of Oracle SQL Developer Data Modeler is now available as an Early Adopter (read, beta) release. There are many new major feature enhancements to talk about, but today’s focus will be on the brand new Search mechanism. Data, data, data – SO MUCH data Google has made countless billions of dollars around [...]

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