Oracle SQL Developer Data Modeler version 4 was released as an Early Adopter just last week. You can go download it here and read about the new features here. A snippet of those new feature release notes… Masking Mask templates can be defined and used in definition of columns with sensitive information. Support for REDACTION policy definition on table and column level. Support for Transparent Sensitive Data Protection (TSDP) policies: Sensitive types can be created…
Hansel and Gretel are in the forest and don’t want to get lost, so Gretel leaves a trail of white pebbles to mark their way. In future adaptations of this Bros. Grimm story, the white pebbles have become ‘breadcrumbs.’ So what does this have to do with SQL Developer? When working with large bits of PL/SQL code, you now have what we are calling breadcrumbs in the editor footer space. Now in the the world…
You may have noticed a few posts lately where I’m talking about new and improved features in SQL Developer version 4.0. You may have also been too busy to read all of them. For shame! But that’s OK. I’ll be doing a webcast with ODTUG on Tuesday, August 20 at NOON Eastern Time. When I’m asked to describe ODTUG, I go with “Well, ODTUG used to stand for ‘Oracle Developer Tools User Group’, but it’s…
Update, July 2018: A reader, thanks Sabine!, noticed the Clone feature is no longer available. This IDE feature was designed for FILES in mind, and it doesn’t extend itself well when applied to our worksheet and database object in the JDev framework. Working on a table? Maybe you need to investigate the stats while you also browse some data. But this is a BIG table. You know how to do the ‘split document trick,’ but…
This feature is going to be hard to cover in a single post, but I’m going to try anyway. The Reports interface received performance improvements, a few tweaks to make them easier to build, a slew of new charting options, and more visual control to tweak. Oh, it’s also available via the command-line interface. Let’s cover the performance bit first. The first time I try to open a report in ‘Edit’ mode in earlier versions,…
“Explain Plans are useless.” Yikes. Really? Don’t we spend all day looking at execution plans? To clarify, I would say that explain plans could be useless. If you do an Explain, you’re actually looking at a theoretical plan, not the ‘actual’ plan. From the docs: With the query optimizer, execution plans can and do change as the underlying optimizer inputs change. EXPLAIN PLAN output shows how Oracle runs the SQL statement when the statement was…
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 over and built a new CLI from scratch. Random Observation: Developers get very excited when they get to redo something. Rather than call the main…
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: 183221637469d22d68e3ca0_000002 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…
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 🙂 For now, just a few points: We’re not distributing the JDK on Windows 32 bit distributions anymore We now require Java 1.7 JDK by default Windows installs will attempt to auto-find the…
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.…