How to get Oracle SQL Developer 23.1 to connect with the Instant Client on Windows – step by step instructions with links and pictures.
How to start using MLE JavaScript in Oracle Database 23c using SQL Developer Web by using a snippet to do a js FETCH, and a module to validate email addresses.
Quick tour of REST API support in Oracle Database 23c Free Developer Release and JSON-Relational Duality Views. All the info and a few demos to get started.
How to Enable thge diagnostic and tuning packs, mongoAPI for Oracle, and tuning ORDS on 23c Free Developer VirtualBox appliance.
Oracle REST Data Services version 23.1 is now available for download! Simpler sign-ins, exporting your REST APIs, and new APEX mgt REST APIS!
Did you know that SQLcl can generate XML changeSets & equivalent SQL files? What about having a rich editing experience directly in the OCI Console?
Enjoyed Maria’s post on comparing pending vs current stats for your tables in an Oracle Database? Well here’s a REST API to do the same thing!
Inserting data to your Oracle Database that includes multi-line strings, including blank lines? You may want to look at SET SQLBLANKLINES.
How to use Oracle SQLcl and the Liquibase DIFF command to compare two schemas in an Oracle Database. This post includes a sample command and report.
You have lots of options for using Data Pump to export your data from Oracle Autonomous Database in the Oracle Cloud (OCI). here’s a quick review!