ThatJeffSmith

Tag: sqldev

Why Can’t I See My Tables in Oracle SQL Developer?

Because you don’t have any tables. I hate to be the bearer of bad news, but you don’t actually ‘OWN’ any tables. What you mostly likely DO have are SYNONYMS that point to tables in a application schema. When you log on to Oracle, you are seeing this: The solution is simple! Enable Synonym Support […]

Locks and Killing Sessions in Oracle SQL Developer

Getting the Windows ‘busy’ hourglass cursor is sure to raise anyone’s blood pressure. Sometimes you’re left there waiting because a resource you’re attempting to access is already being used by someone else. So you get to WAIT. You are being BLOCKED because what you want is LOCKED. How can you see what the hold-up is? […]

Oracle SQL Developer Data Modeler: Using Displays…

…to Create Alternate Visual Presentations of your Diagrams Your data model tells a story, and we all learn as small children that the best stories have pictures – the more the better! There’s a reason I try to always have at least one picture in my blog posts – even adults are easily distracted. We […]

How to Plug vi into Oracle SQL Developer

Love vi? Prefer emacs? Want the power of the 80′s added to Oracle SQL Developer? You can do that via our External Tools feature. And you can even have SQL Developer throw over your open file into vi, edit it, save it, and refresh the buffer in the worksheet to reflect the file changes. Here’s […]

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