Hot to build a REST API to update a record in the Oracle Database, using new 23c RETURNING OLD clause – see what the previous and new value are!

Hot to build a REST API to update a record in the Oracle Database, using new 23c RETURNING OLD clause – see what the previous and new value are!
Do you know what’s possible at the command line when working with your Oracle Database? Here’s a quick reminder of what Oracle SQLcl brings to the table.
Our first update (bug fixes!) is now available for Oracle SQL Developer’s extension for VS Code … version 23.4.1! Here’s a quick overview of what’s been addressed.
How to change the keyboard shortcuts in VS Code for doing things like executing a SQL statement via the SQL Developer extension.
With our new Oracle SQL Developer extension for VS Code, we made sure to also include a FIRST CLASS command line experience!
Working with your database objects, including how to manage data in your tables (complete with BLOBs!) using our Oracle SQL Developer Extension for VS Code.
How to navigate your Oracle Database from your PL/SQL and SQL code in VS Code using Peek and Go To Declaration features.
A quick overview of what we offer in terms of code completion in Oracle SQL Developer for VS Code and a quick word on Snippets.
How to get DEBUG info and logs from when something isn’t working in our Oracle SQL Developer Extension for VS Code, including our SQL and PL/SQL code!
How to import your connections from Oracle SQL Developer to VS Code using SQLcl, it’s easy!