How to See Two Tables at the Same Time in Oracle SQL Developer

Another post from the FAQ files:

HOW TO OPEN MULTIPLE TABLES IN SQL DEVELOPER SIMULTANEOUSLY

I’m guessing the user is in a hurry, hence the shouting and lack of punctuation. But that’s OK, I think we’ve all been there.

There’s a couple of different ways to get this end result:

  1. (more...)

Using the KScope13 Mobile App Schedule Builder to Maximize Your Oracle SQL Developer Experience!

ODTUG’s KScope13 event is just around the corner. This year, as always, we have a ton of Oracle SQL Developer content ready to share in the form of sessions, hands on labs, and symposiums. I’ve noticed a few of our users are also sharing their experience in their own sessions (more...)

Ever Run a Truncate, Drop, or Delete in the Wrong Database?

Hurts, doesn’t it? And tools make it so easy to do this. Even though your tool probably reminds you where you’re at, your brain often just starts running after the next task. And usually your fingers are even a few steps ahead of your brain. And then you get into (more...)

An Oracle Designer Feature: Generating Table APIs with Oracle SQL Developer

Have you heard of Oracle Designer? Perhaps you even still use it?

Designer incorporates support for business process modeling, systems analysis, software design and system generation.

I don’t want to get you too excited, because this technology is being phased out. You can read the official statement of direction here (more...)

How to Synch your Oracle SQL Developer Data Model to a Different Database

First a couple of quick notes:

So the challenge presnted is: who do I (more...)

Oracle SQL Developer: Database Object Shortcuts?

An interesting question popped up on the forum, and I thought I’d share my ‘answer’ with you folks. I figure this is something a lot of folks do several hundred times a day – pulling up a frequently used database objects in the browser.

The question:

Is there a way (more...)

Oracle SQL Developer: What’s Next?

Software development never really stops. The development cycle is truly a circle. Once a release is ready, the developers don’t go on break awaiting orders. There’s always the next sprocket to build or widget to refactor.

And so comes one of the best parts of my job: helping figure out (more...)

Oracle SQL Developer Data Modeler v3.3 is Now Available

sqldevDM33Oracle’s free data modeling solution, Oracle SQL Developer Data Modeler, has been updated with the release of version 3.3. I’ve already previewed a few of the new features here, and I’ll continue to talk more about the latest and greatest features. You can see the full list of (more...)

Oracle SQL Developer Report: Tables By DataType

When I’m doing demonstrations of Oracle SQL Developer, I’m frequently asked about our support for datatypes like XML, BLOBS, Timestamp, etc. When I’m put on the spot like that, I have a tendency to forget that I already have tables setup for this. So I end up writing a query (more...)

How to Create or Open a Data Model in Oracle SQL Developer

The Oracle SQL Developer family currently has two ‘SQL Developer’ branded products:

  1. Oracle SQL Developer
  2. Oracle SQL Developer Data Modeler

Oracle SQL Developer is the database IDE and Oracle SQL Developer Data Modeler is our dedicated data modeling solution. Where it gets interesting is that the entire Data Modeler product (more...)

Managing Table and Column Comments in Oracle SQL Developer

An interesting question came up on the ORACLE-L mailing list this morning regarding table comments:

Just wanted to get a general opinion on using comments in the database. For example COMMENT ON COLUMN table.column “No comment”.

Does anyone do this as a regular best practice? I would prefer to (more...)

Four Oracle SQL Developer Preferences You Should Know

In an earlier blog post I listed my ‘Top 10 Preferences to Tweak…’ Instead of amending that to Top 14, I wanted to give a fresh and updated take on some features that directly impact productivity and data quality.

After doing three customer calls in three consecutive days, (more...)

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:

Your Table List is Empty!

Your Table List is Empty!

The solution is simple!

Enable Synonym Support in the Tables Filter Dialog

Mouse-right click on your tables tree node, and select ‘Apply Filter…’

Treat Local Synonyms for Tables as Tables

Treat Local Synonyms for Tables as Tables

With this checked, bam!

Oh my sweet, sweet darlings, how I missed you.

Oh my sweet, sweet darlings, how I missed you.

Note: This is also (more...)