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: 458367667680cd2626a5a3_000000 Accessing the ‘Tip’ Place your mouse over the red squiggle line indicator… Once the tip is available, you can invoke the grammar ‘fix’ by clicking on the hyperlinked…
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 very the second I shared THE DATE, I’d be branded a liar. You see, dates slip. And being in a position to not ship product…
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 presentations, Hands On Labs, and of course the demo pods to man in the Exhibitor Hall. 2013 takes it up a notch or three. We’ll have 8 official SQL Developer-themed sessions, 5 Hands-On Labs, and 3 Demo Pods.…
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 have said a couple of things, oh well I use Camtasia Studio 7 from TechSmith If you want a more official ‘answer’ to this question,…
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 minute they were published? An enterprising DBA-extraordinaire who was just happening to be presenting at the ODTUG KScope13 conference in New Orleans. He thought it would…
SQL Developer has had an object search for quite a while, however we decided it wasn’t good enough, so we enhanced it! You can now search more things, and the search results are easier to work with. Here’s a quick demo to see it live in action: How it works For your your connection, you’ll need to set a few search parameters, the SCHEMAs you want to look into, and then what you want to…
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 something is in a database, then it can be accessed via SQL. So how can I leverage all the data in my designs without having to…
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 I can’t comment on when that will change, I can say we’re getting closer 🙂 I thought I would reward my loyal readers with a quick…
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: Use the Pins Change the Preferences Pinning Objects At the top of every editor in SQL Developer, you’ll see a push pin button in the…
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 – awesome! If you’re going to Kscope13, you’ll want to make sure to carefully setup your schedule so you don’t miss a thing 🙂 I’ve…