The evolution of Oracle Database REST API development interfaces in SQL Developer, APEX, SQL Developer Web, and SQLcl for ORDS.
Oracle SQLcl version 22.1.1 was released today. Some bug fixes and a Liquibase library update. Plus a quick note on Oracle Cloud Console updates.
Nothing but Oracle SQL Developer WEB tips and tricks…the movie! My talk from Oracle Database World, Spring 2022.
How can I build a REST API for my database that just returns a simple array populated from a SQL SELECT query? Easy, write a few lines of PL/SQL and use ORDS!
Release announcement for Oracle REST Data Services (ORDS) version 22.1, and you really need to read the README this time.
Oracle SQLcl version 22.1’s new SQL performance code scanning rules, where they came from, and some examples. Find bad SQL before it hits production!
SQLcl gets quarterly updates and it’s again that time of year! DOWNLOAD NOW — this is the ‘latest’ link, you can permanently bookmark this. Don’t pass go, don’t use Java 8. Java 1.8 or Java 8 has been around since 2014. We now have long term support releases 11 & 17 as well. Starting with the 22.1 release cycle, Oracle Database Tools (ORDS, SQLcl, SQL Developer, Data Modeler) will no longer support Java 8. Officially…
How to get OpenAPI 2.0 vs OpenAPI 3.0 specs on your REST Enabled Objects and REST Modules from Oracle REST Data Services.
How to use the built-in OpenAPI (Swagger) REST client in Oracle REST Data Services to test your POST endpoints for your Oracle Database REST APIs.
How to cURL Oracle Database Data Pump Export job in your Oracle Autonomous Database, via Oracle REST Data Services (ORDS) – code & screenshots!
Slides and video from our data loading tips and tricks webinar we had with about 135 of our friends.
I do some live demo and share some tips for getting your data imported quickly AND CORRECTLY from CSV or Excel to an Oracle Database.
Release News: Some updates with bug fixes for ORDS, SQL Developer, and SQL Developer Data Modeler Oracle customers. Quick overview and download links.
How to model templates and write handlers for tables with multiple primary keys for Oracle using REST Data Services (ORDS).