Oracle Database 12c SQL Translation Framework: Fixing Bad SQL

thatjeffsmith SQL Developer 0 Comments

One of the new Database 12c features is the SQL Translation Framework. Developed primarily to help customer migrate their 3rd party applications and databases to the Oracle stack, it also offers application DBAs an opportunity to substitute poorly performing SQL with their own custom SQL – without changing the application itself! Do I have your attention now? Kerry Osborne wrote …

‘Forcing’ Line Breaks in Oracle SQL Developer

thatjeffsmith SQL Developer 7 Comments

Oracle SQL Developer is at its heart, an Interactive Development Environment (IDE.) So it comes with the territory that developers should expect to be able to write good code quickly. One of the many code ‘helpers’ that a good IDE will provide is a Formatter. Formatters, or code beautifiers as they’re also known, take poorly formatted text and make them …

Click AND Type your Queries with the Integrated Query Builder

thatjeffsmith SQL Developer 23 Comments

I was perusing the SQL Developer Feature Requests Exchange and was not surprised to see this – a request to have the Query Builder disabled. My favorite (and most predictable) comment among the voters for this request is something along the lines of ‘feature totally useless for us professionals’ Let’s explore that for a second. First of all, I’m not …

Watching Paint Dry or V$SQLTEXT_WITH_NEWLINES

thatjeffsmith Database Stuff 1 Comment

How much time to do you spend debugging database application problems? Probably more time than you want. How much of that time is spent capturing the SQL that is being submitted by your application to the database? I’m going to guess that it’s a significant amount. Asssuming you have access to production (or a test environment that adequately replicates production), …