Not able to make my Tips & Tricks talk at the Great Lakes Oracle User Group conference this week? Don’t have the 50 minutes to watch my recorded YouTube version? Can you spare 90 seconds? You don’t even need to turn the sound on. Just watch this GIF. To recap: ALT+G to do a search Use Doc Tab Groups to …
Demonstrating Oracle SQL Developer Web: the Data Modeler
In this 10 minute video, you get: super quick recap of the Worksheet building a new diagram moving stuff around, changing the colors generating DDL generating a data dictionary report saving and searching diagrams This was my 50th post on YouTube. If you like what you see, be sure to subscribe there so you don’t miss any updates. Your subscriptions …
Announcing Oracle SQL Developer Web!
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 …