A collection of thoughts and idea for the Oracle SQL Developer user looking to get started with working with Oracle Database in VS Code.
An example Flask web app that interacts with an Oracle Database, via ORDS REST APIs. You can pull local and build this yourself or use our hosted LiveLabs!
Oracle SQL Developer’s extension for VS Code DOES support a code outline for SQL and PL/SQL – here’s a quick demo!
How to load pre-built embedding generation model into Oracle, compute VECTORs, create VECTOR INDEX, and find similar text with the VECTOR_DISTANCE function.
App developers, learn how to use REST APIs to get the most out of your Oracle Database with our new Hands On LiveLab at Cloud World 2024
How to filter or search your Oracle Database 23ai JSON Relational Duality Views using REST APIs, a simple example using our simple dot notation.
Oracle Database 23ai FREE has been updated to version 23.5, and that’s now available via our VirtualBox Appliance. Also – easier onramp to building APEX apps!
An overview of using SQL Developer extension for VS Code to point and click your way through building Oracle 23ai Duality Views.
How to build a Liquibase changeLog to create your Oracle tables, load the data, and publish their REST APIs, automatically with SQLcl.
Oracle Database 23ai had a primary objective – make the Oracle Database more developer friendly. One of the byproducts of that mission, was more useful error messages, including ORA-00918 & ambiguous column names.