ThatJeffSmith

Tag: sqldev

Oracle SQL Developer Quick Hit: Paren Matching

Today’s Question: Does anyone know of an editor (or program) that will match beginning and ending parentheses in sql and highlight an ending paren that is missing? It just so happens that I do know of such an amazing editor or program I’ll let the pictures do the talking for me this afternoon: Matched Parens […]

A SQL Developer Primer: Open a New Worksheet

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

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

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

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

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