We’ve gone a bit manic when it comes to releasing updates for SQL Developer:- 4x a year, or once a quarter. We’re committed to delivering on this schedule, but we reserve the right to skip a release if there’s no urgent need. More frequent releases means not as much time to wait for bug fixes, and also that new features will be rolled out in smaller changes vs more dramatic ones. Here’s where we’ve been:…

Normally when someone asks me about ordering packages, I check the doorstop for our daily Amazon delivery. Ok, it just seems that way, and I’m lucky that my awesome wife/partner doesn’t read this blog… …but what we’re really here to talk about is finding stuff in your PL/SQL package. I think there are 2 types of folks: Those that code willy-nilly: they build out each variable, procedure, type, function as it pops into their mind…

This blog post was going to be JUST that picture above. The size of the logos show what I think are the importance, reach, or quality of their content. But I figured I should throw some words and numbers to go with it. You might now know this, but I’m a bit obsessed with Social Media. It’s worked for me, and I think it can work for you too. But where to spend your time?…

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 them. We even talk about this in the Oracle Database Docs and provide some examples…

Version 18.1 of SQL Developer is now available. Go download that here. Most importantly, there are a TON of bug fixes in this release. Many of them reported on twitter, blog posts, and our forums. So thanks again for all that feedback. Today I want to talk about the first thing you’ll see, our new ‘Welcome Page.’ It used to look like this – Then it went to this – Make it better AND more…

SQL Developer’s code editors try to help you out. They’ll show you two categories of informational advisories: there is a problem with this code we think we can help you with this code These are shown by various styles of underlined text in the editor. Let’s go through the list of what’s available as of version 18.1 – to be released, soon 🙂 Actually all of these items, save 1, are available right now in…

I’ve been tweaking how my SQL Developer application looks and feels for a long time. Someone saw my desktop and wanted to know how to make theirs look like mine, hence this post. I realize beauty in in the eye of the beholder, but if you behold what I behold, then here’s how to get there. I recently came across this Scheme on GitHub, and have been using it for a few months now. It’s…

The search feature in SQL Developer is whiz-bang. You’re using it, right? But what about at the command line? I’m guessing many of you just pluck away at ALL_ or DBA_OBJECTS. Some of you may have written some custom scripts. But, what if you burned that into SQLcl? You can of course do this with the ALIAS command. You can say, ALIAS XZY=query; And then access the query by just executing XZY. AND, you can…

When you AUTO-REST enable table in ORDS, we publish a full API for you: We auto find your Primary Key Column and use that to address particular rows (items) in your table (collection.) But..what happens if you don’t have a primary key? 1864068885c6b7d2dd6af0_000005 REST enable that… 1864068885c6b7d2dd6af0_000006 And now let’s ‘GET’ the table. So let’s try that… Hmmm, that ‘%2’ part doesn’t look right to me. That’s actually ‘%2B’ which is a way to escape…

Let’s say you have a schema you want to reverse engineer and generate some docs. Lo and behold, the developers used foreign keys! But…there are so many of them, I can’t see the forest for the trees. So how do we make this simpler? Well, our developer for the Data Modeler showed me this trick: In his words: when use synonyms is checked tables that are referred more than 9 times are removed from global…

The Automatic REST features in ORDS are very handy for getting started quickly with providing REST APIs to your data and stored procedures. Give me the data for an employee. Easy. REST enable the schema. REST enable the table. DO a GET on /ords/schema/table/id. But…I don’t want a ‘null’ in my JSON collection for value pair “commission_pct.” What’s an Oracle developer to do? Code/Roll your own REST Service. The ‘bespoke’ solution took me about 3…

A customer ‘ambushed me’ – how dare they!?! – at the conference today, needing help getting their scripts to work. So something like this: And the way the customer wants to run scripta.sql (which calls scriptb.sql) So, where is SQL Developer going to look for scriptA? And when it gets to the @child\scriptb.sql? We can call scripts.sql using @c:\users\jdsmith\desktop\parent\scriptA.sql But, we’re going to have a problem. So, you have 2 options. First, you COULD tell…

I’m in Denver today, to present one of my favorite talks, SQL Developer Tips & Tricks. Since I know most of you won’t be here today, I thought I’d share 3, super-quick tips. I get asked ‘how to do this’ type stuff, all the time. Copying Column Headers with your Data Ctrl+Shift+C Showing Line Numbers Right-click in the gutter, turn it on. It’ll remember this going forward. You’ll need to do it for the…

I see questions like this on StackOverflow and related websites like, ALL THE TIME: I have some code, what’s wrong with it? Something I wish I could do, other than physically hold the person’s hand, is show them how our IDE tries to point them in the right direction of their syntax issues. But since I can’t do that, I’ll write a quick blog post and help the Google gods can help folks going forward.…