One of the more popular features in SQL Developer is the ability to generate the CREATE DDL script for any object. If you open an object editor, the SQL page shows this script.
You’ll see this ‘SQL’ page for each type of database object editor in SQL Developer
Now, what many of you don’t realize is that the way this code can be generated is configurable.
The requests I am most frequently asked to demo (more...)
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:
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...)
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...)
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...)
First a couple of quick notes:
So the challenge presnted is: who do I (more...)
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.
Is there a way (more...)
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’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...)
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...)
The Oracle SQL Developer family currently has two ‘SQL Developer’ branded products:
- Oracle SQL Developer
- 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...)
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...)
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...)
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!
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
With this checked, bam!
Oh my sweet, sweet darlings, how I missed you.
Note: This is also (more...)