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…
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, but but going forward we’re recommending you use JDeveloper, Fusion, and our other middleware technologies to build your applications. What I want to get to,…
First a couple of quick notes: You can synchronize your model or your database and generate an ALTER script When you import one or more objects from a data dictionary to your model, it ties that model to that particular database So the challenge presnted is: who do I compare my model against a different database and generate an ALTER script? The answer is easy: Upgrade to version 3.3 of Oracle SQL Developer Data Modeler…