A new feature in Oracle SQL Developer version 4.0 offers to address grammatical issues with your SQL statements. We call these indicators ‘Semantic Analysis Info Tips.’
The easiest way to see one of these ‘tips’ is to try out your favorite sql statement in a worksheet:
SELECT * (more...)
Yesterday I installed SQL Developer 4 on a Virtualbox VM that also contains Oracle 11g R2 and SQL Developer 3.2.20. I had no issues installing it; but as soon as I started clicking on anything that required a database connection (which is pretty much everything), the following error (more...)
So go download it.
I’m at the beach this week, not working. Mostly.
I’ll be talking about our newest addition to the family, pretty much non-stop, starting next week and stopping when version.NEXT is released. You have plenty to look forward to
Perfect weather and no fog to cloud the view! Post OOW12 bridge run
Oracle Open World 2012 left me exhausted. Apart from the social and fun stuff like running across the Golden Gate with a few co-workers and keeping up with social and business dinners, we had a ton of (more...)
Organizing your data model makes the information easier to consume. One of the organizational tools provided by Oracle SQL Developer Data Modeler is the ‘SubView.’ In a nutshell, a SubView is a subset of your model.
I’ve just created a model which represents my entire ____________ (more...)
As you may have heard, Oracle Database 12c is now available. In addition to the binaries and docs going out, we also published a few new Oracle By Example (OBE) chapters. You can find those links here on our product page.
Do you know who found these, practically the (more...)
Oracle SQL Developer version 4.0, Find DB Object
Bonus Post from ODTUG’s KScope13
A few folks commented they liked the animated GIF’s I had integrated into my Oracle SQL Developer v4.0 New Features Symposium talk. We’ll here’s the first one. I thought everyone might like a to take (more...)
The current version of Oracle SQL Developer requires at least Java 6, e.g. the 1.6 JDK. I talk about Java, JDKs, JREs and what all that means in a previous post if you need to catch up on the lingo.
Many versions of Java out there – 5, (more...)
You’re doing some data clean-up, or maybe you’re just trying to answer a business question for a user, and you notice the data doesn’t look quite right.
Name that tune…
You want to click in that ‘(null)’ cell and tell the world that Tyler and Perry composed that song! But, (more...)
Oracle SQL Developer Data Modeler has a multi-user repository that makes it very easy to control and version changes to your data models and designs. However, it’s stored in a Subversion (think files) repository. Many of our users are accustomed to having EVERYTHING stored in the database.
And when (more...)
In a few weeks I’ll be speaking at the Database Symposium at the ODTUG KScope13 conference. My topic, ‘SQL Developer v4.0′ will be one of the first times I spend an entire hour showing off our new features in the upcoming release.
While not yet publicly available, and while (more...)
To reverse engineer an existing database into a relational model, I used SQL Developer Data Modeler, a free data modeling and database design tool from Oracle.
I had a problem with the tool. I could not save the model. It appeared to be saved but when I reopened the . (more...)
Interesting question from the forums:
I’m doing multiple Inserts on a table using a script file (.sql) in SQL Developer.
Since it has a lot of statements, I would like to check the progress of it somewhere in the application window. But I don’t see any progress of lines (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...)
Running lots of scripts in SQL*Plus is nice when they are working correctly. But what about when they fail? Its a pain to figure out what went wrong, unless you have a log file and even then, you have to hunt the errors down.
Well, I've had enough of that. (more...)
When you have a load of SQL*Plus scripts, they can be a pain to manage and just simply get around.
In the next version of SQL Developer, you'll be able to hold the ctrl key down and click on the file name and have it open up. This also works (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...)