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.
Here are the slides and video recording of our 5 year happy birthday party for Oracle SQLcl, your modern command-line interface for the Oracle Database.
Using ORDS and our database REST APIs to monitor your APEX instance and applications.