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

Similar Posts by Subject Areas: , , , ,

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: SELECT * FROM scott.emp; Accessing the ‘Tip’ Place your […]

Similar Posts by Subject Areas: , ,

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

Similar Posts by Subject Areas: ,

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

Similar Posts by Subject Areas: , , ,

Preserving Privilege Grants Whilst Editing Views in Oracle SQL Developer

Today’s Question: How do we prevent Oracle SQL Developer from dropping the grants/privileges when modifying a view. While using SQL Developer we modified a view and once saved it removed all of the user access previously set up for the view. This did not previously take place when using… Ugh. That doesn’t sound good at […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,