SQL Developer has had a command-line interface of sorts. The primary use cases were for formatting files and running unit tests. However, we wanted to expand the support to include things like generating Carts and running reports.
Instead of just creating a few more one-off interfaces, we kind of started (more...)
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...)
Being asked when the next version of your product is going to be released is a gut-wrenching question. The community gets excited when a new release is due – who doesn’t like new things to play with?
And I’d love to tell everyone when exactly that will happen.
But, the (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...)
I get this question a lot. The question tells me a few things:
- you LIKE the animated GIFs here on thatjeffsmith – cool, I’ll keep doing more
- you want to make your own – awesome, I’m helping make the world a more animated place
- that’s pretty much it, I should (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...)
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...)
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...)