I’m new to Oracle, and I need a database…help!
Database Stuff

I’m new to Oracle, and I need a database…help!

Taking an Oracle Database class or course? Need to get up and going on Oracle Database really fast, and really easily? Here’s my advice!

Read More
REST APIs and TABLE INSERTs: the Definitive Guide for Oracle
ORDS

REST APIs and TABLE INSERTs: the Definitive Guide for Oracle

REST APIs and TABLE INSERTs, everything you need. Bonus: we’ll build a REST API to GET the data, with support for CLOB/JSON, links, and exception handling!

Read More
SQL Developer

Update: we’ve introduced a new feature for managing your database changes, including your APEX apps and ORDS REST APIs, via the Project command. Learn more here. LIQUIBASE does ‘Source Control for your Database.’ It’s an Open Source project that allows you to capture changelogs for your database, including Oracle. What we are doing: Extending the support for Oracle to include all schema object types Building an interface directly into SQLcl via a new LB (LIQUIBASE)…

ORDS

Today’s question: Does ORDS support PUT/POST with Array or Cursor as part of the payload? I need to call a procedure with 1 IN parameter defined as Array or Cursor (for a list of IDs). The answer is Yes, and I’ll show with the AUTO Feature. The Underlying Code: 18052921846863a2e470fd8_000005 Executing FORUMS_PLSQL_TABLE.INS_C() via POST First, let’s Auto PL/SQL Enable the Package. 18052921846863a2e470fd8_000006 Second, let’s call the package. 18052921846863a2e470fd8_000007 So in my POST I passed a…