We are now live in the Oracle Cloud with Oracle SQL Developer Web. Wait, what’s SQL Developer Web? It’s a browser based version of Oracle SQL Developer powered by Oracle REST Data Services. If you are a Database Cloud Service customer in the Oracle Cloud, it’s rolling out now to those subscribers. If you’d like to know more and see …
How to Hide Schema Notation in your Data Modeler Data Dictionary Reports
Someone asked, hey, I know how to hide the schema notation in our diagrams You can too – READ THIS POST – …but (there is always a BUT), how can we hide it from the data dictionary reports as well? The answer is – you need to manage the report template. When you open the Report dialog, switch to the …
How to Compare a Specific Subset of DB Objects
A question from the innerwebs – Hello, please, is it possible to define and save a (sub)set of objects for comparison? In Databasediff wizard we have an option to define objects, but it’s a bit cumbersome to do the same thing over and over again, so it would be highly useful to save options and selected items for comparison for …
All About Versions – Time to Upgrade?
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 …
More on Working with PL/SQL Packages – Ordering their Contents
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 …
Ranking Social Communities for the Oracle Database Professional
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, …
18.1 – New Formatting Option, Right-Align Query Keywords
Due to popular demand, we’ve added this new preference to the formatter. With it turned on: On SELECT B.DEPARTMENT_NAME, A.FIRST_NAME, A.LAST_NAME, A.SALARY FROM DEPARTMENTS B, EMPLOYEES A WHERE A.EMPLOYEE_ID = B.MANAGER_ID AND B.DEPARTMENT_ID (+) = A.DEPARTMENT_ID ORDER BY SALARY DESC, LAST_NAME ASC; Off SELECT B.DEPARTMENT_NAME, A.FIRST_NAME, A.LAST_NAME, A.SALARY FROM DEPARTMENTS B, EMPLOYEES A WHERE A.EMPLOYEE_ID = B.MANAGER_ID AND B.DEPARTMENT_ID (+) …
18.1 Features: SQL Injection Detection
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 …
18.1 is Now Available – Easier Connections!
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 …
Let’s talk about ‘Squiggles’ – What’s Wrong with Your SQL or PLSQL?
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 …