ThatJeffSmith

Tag: 4.0

Explain Plan and Autotrace Enhancements in Oracle SQL Developer 4

“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 […]

Preserving Line Breaks in Oracle SQL Developer 4

Ugly code, we all write it. I don’t mean bad code either, just hard to read code. Developers who haven’t figured out how to use the TAB and ENTER keys – what’s up with that? — and why is Jeff talking to himself in his Seinfeld voice again? So one of the features in SQL […]

Semantic Analysis Info Tips in Oracle SQL Developer 4.0

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: Accessing the ‘Tip’ Place your mouse over the red […]

Oracle SQL Developer 4.0 Is Finally Here

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 […]

A Sneak Peek: Oracle SQL Developer Version 4.0

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 […]