A small feature that could have a huge impact on your code – we try to make sure you know your PL/SQL might be vulnerable. SQL Injection is a very well known security risk in the database world. Nefarious people could ‘inject’ SQL into the code you’re about to execute via some some of user input you make available to …
Quick SQL – A New Way to Generate Objects in APEX 5.1
Oracle Application Express on APEX.ORACLE.COM was upgraded to v5.1 last week. One of the new things coming in v5.1 is a new packaged app called ‘Quick SQL.’ VP of Development Tools Mike Hichwa demonstrated it at UKOUG Tech 16 this month, and the audience seemed to eat it up. Basically, it allows you to use a shorthand of sorts to …
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 help you quickly find these …
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? No worries, pull it up …
Quick JSON Query Tip: Use Column Aliases for Arrays of Objects
This isn’t a SQL Developer post, sorry folks. When it takes me more than a couple of Google searches and more than a little bit of poking around to figure something out, I reckon it’s blog-post-worthy. Maybe I can save you a bit of time too! I have: a 12.1.0.2 database the JSON patchset a table said table with IS …
We Want You..to 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 – funny how those words …
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 we’re now seeing the SQL …
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 only thing that runs there …
Oracle SQL Developer version 4.1 Early Adopter Now Available
Go get it. Then come back here and read a couple of things. it REQUIRES Java 8 it’s not production ready – send feedback to the Forum not to Support Two new features to help you get started. SQL Formatting in the Worksheet Like the /csv/ formatting ‘hints’ you can add to your statements? Well now, you can just toggle …
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 Objects, Side By Side So …