More on using the JSON interface in SQL Developer Web to filter/query and understand your JSON Collections in an Oracle Database.
Versions 21.4 of SQL Developer (Desktop) and Data Modeler have been released. These updates include bug fixes and address the recent log4j CVE.
Here’s another example of building a Charting Dashboard, but this time I’ll share the SQL, and the data will be interesting for live updates/refreshes.
I’ve shared a dashboard and set of charts showing off our latest reporting feature in Oracle SQL Developer Web. Powered by REST APIs and Oracle JET.
An overview of the SQL Worksheet feature in the new DBTools Service in the Oracle Cloud (OCI).
Lots of demos and gifs to get you started on running your SQL.
Here’s my 30 minute tips and tricks overview for ALL of our Oracle Database Tools from Oracle Database World 2021 – SQL Developer, SQLcl, ORDS, and more!
Identifying who the authenticated user is in your Oracle REST APIs (ORDS) when using OAuth2 with the implicit bind, :current_user.
Point Oracle SQLcl at a CSV file, and we’ll figure out the CREATE TABLE for you AND load the data, all in one command!
Only want the DDL? No problem!
How to set coloring options in Oracle SQLcl for your prompts, code, and query results.
A powerful tip for your Oracle Database command line experience.
How to pass DATEs and TIMESTAMPs in your HTTPS requests to Oracle REST Data Services and your REST APIs for the Oracle Database.