Tag: sql

2 Reports You Might Enjoy in Oracle SQL Developer

I keep telling people our reporting functionality is probably the most powerful AND overlooked feature in SQL Developer. Today I’m going to share 2 reports that I frequently forget about, that you may enjoy. Finding Unindexed Foreign Keys We all know this should not happen. We all know it eventually happens. Here’s a report to […]

Similar Posts by Subject Areas: , , , , ,

What the SQL? (History)

Oracle SQL Developer has 2 client-side logging mechanisms for capturing SQL that is executed: SQL History Statements SQL History This is the SQL that you have executed in a SQL Worksheet. It’s also any scripts you have executed in a SQL Worksheet. Ran something the other day and forgot to save it to your script? […]

Similar Posts by Subject Areas: , , , ,

We Want Eat, Breathe, and Live SQL

Our developer advocate team, led by Steven Feuerstein of PL/SQL fame, is looking for someone to help spread the good word – about SQL. You can read about the job here, but I thought I would throw in my two or even 3 cents on the matter. I have been evangelizing or advocating or helping […]

Similar Posts by Subject Areas: , ,

SQL Developer and a 12c Magic Trick

When you start working with 12c, if you want to freak out (sorry, GRAB the attention of) your co-workers or folks attending your presentation, try this: Open a worksheet Write a simple query against a view, or a data dictionary view Mouse over the SELECT and wait… Should just take a second or so… So […]

Similar Posts by Subject Areas: , , ,

SQL Developer 4.1 – Log All the Queries!

Oracle SQL Developer is a graphical user interface and integrated development environment for Oracle Database. As you can imagine, a few clicks can results in an awful lot of queries being executed on your behalf. If you don’t like this fact, you can always use a command-line interface like SQL*Plus or the new sdsql. The […]

Similar Posts by Subject Areas: , , , ,

30 SQL Developer Tips in 30 Days, Day 10: Compare Stuff Side By Side

We try to make comparing things easy to do. When you’re troubleshooting, you frequently need to know why A isn’t quite like B. So let’s look at a few scenarios. Execution Plans or Autotrace Runs Run a plan or autotrace. Pin it. Run another. Right-click on one, and compare with the other. Voila. Looking at […]

Similar Posts by Subject Areas: , , , , , ,

Oracle Database 12c SQL Translation Framework: Fixing Bad SQL

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

Similar Posts by Subject Areas: , , , ,

Oracle SQL Developer: Configuring Object DDL Scripts

One of the more popular features in SQL Developer is the ability to generate the CREATE DDL script for any object. If you open an object editor, the SQL page shows this script. Now, what many of you don’t realize is that the way this code can be generated is configurable. The requests I am […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,