#oraclerest
It's nearly time...

Oracle Critical Patch Update Pre-Release Announcement - October 2025

www.oracle.com/security-ale...

@OracleDatabase @OracleREST @OracleAPEX #orclapex
October 17, 2025 at 8:47 AM
Step-by-step...by-step: Building a RESTful Web Service (PUT) to update a record, and get back the new values using @OracleREST and @OracleSQLDev Web.

How detailed is this?
16 pictures
100+ lines of code

#oracle #rest #data #http
November 13, 2024 at 5:27 PM
Webhooks can be finicky…here is how we helped a customer interrogate theirs using ORDS Implicit Bind Parameters followthecoffee.com/ords-as-a-jo... #oracle #ords #oraclerest #apiintegration #apidevelopment
ORDS as a JotForm webhook: An actual customer use case – Follow the Coffee
followthecoffee.com
December 31, 2024 at 6:02 PM
Today's blog post was number 100 for @OracleREST :)

Only took 6 years...wait, that sounds horrible!
November 13, 2024 at 1:27 PM
New post (from late yesterday)

Having problems getting your connection pools established with @OracleREST ? Here are some troubleshooting tips and techniques!
https://www.thatjeffsmith.com/archive/2023/01/troubleshooting-ords-startup-errors-the-pool-is-invalid/

#oracle...
Troubleshooting ORDS startup errors, the pool is invalid.
Troubleshooting guide for starting up Oracle REST Data Se...
www.thatjeffsmith.com
November 13, 2024 at 3:26 AM
Join our @OracleDatabase tools team for Oracle Database World later this month - details and a preview for my Tips & Tricks talk that covers ALL of our products...
@OracleSQLDev (Desktop, Web, and Data Modeler)
@oraclesqlcl
@OracleREST...
November 13, 2024 at 11:30 AM
In about 25 minutes @btspendo will take you though @OracleREST for #OracleDevLive - click here to join

https://developer.oracle.com/developer-live/app-dev-database/

I'll be helping answer questions, and then we'll take you through our new Live Lab where you can learn to use this...
Oracle for Developers | Programming Languages, Tools, Com...
developer.oracle.com
November 13, 2024 at 1:54 PM
Tip: Let @OracleREST do the work for you! For ANY SQL based API (includes AutoREST tables & views) - tack on query parameters to filter, order, ... your results

#oracle #SQL #APIs
November 13, 2024 at 7:20 AM
It's Release Day for @OracleREST @oraclesqlcl !!

The Blog Post:
https://www.thatjeffsmith.com/archive/2023/07/oracle-sqlcl-and-rest-data-services-23-2-are-now-available/

Docs will be live, shortly.
Oracle SQLcl and REST Data Services 23.2 are now available!
Oracle SQLcl and REST Data Services (ORDS) versions 23.2 ...
www.thatjeffsmith.com
November 12, 2024 at 5:47 PM
Our @OracleREST @oraclesqlcl teams are looking for a #Java developer with some @OracleDatabase experience - ping me or @bamcgill if you're interested #jobs #Developer
November 13, 2024 at 1:40 PM
I reference this post quite a bit, how to tell @OracleREST that your output is already {json} and you don't want it formatted, again.

If you're using PL/SQL, you'll need to print the response yourself via...
November 13, 2024 at 11:56 AM
Talking about @OracleSQLDev for DBAs next week! Thanks @odtug for the oppty

https://www.odtug.com/page/odtug-learn-from-home-series#database-dba

I'll also be talking all about @OracleREST with @krisrice in back-to-back talks...
November 13, 2024 at 9:01 PM
New Blog Post : ALL THE THINGS - Project Outline. #orclapex @OracleJET @OracleSQLDEV @oracleREST. https://wp.me/p9wMCV-3h
Doug Gault - Life, The Universe and Oracle
Information and articles about Oracle Database, Oracle AP...
wp.me
November 22, 2024 at 10:50 AM
New post! Showing to take advantage of Spatial features in @OracleDatabase with @OracleREST and SQL.

https://www.thatjeffsmith.com/archive/2022/06/on-rest-apis-gps-coordinates-spatial-and-geojson/

#GPS #JSON #SQL #data #Oracle
November 13, 2024 at 7:09 AM
New "All the things" blog post. Workflow - Checking out the competition. #orclapex @oracleRest @OracleSQLDev @oracleJET http://douggault.com/2018/01/31/workflow-checking-out-the-competition/
404 - Not found
Oops! Page not found. This page doesn't exist or was remo...
douggault.com
November 22, 2024 at 10:42 AM
In this new post, I'll show you how to stream/download files using @OracleREST from your @OracleDatabase using
+ just SQL
+ SQL which calls PL/SQL
+ just PL/SQL

https://www.thatjeffsmith.com/archive/2021/03/downloading-streaming-content-with-ords-file-downloads/

Yes, I've done...
November 13, 2024 at 3:04 PM
New Post!

Learning @OracleREST by Example - Creating REST APIs for AWR with ORDS and SQL

Huge HT @krisrice

#oracle #database #rest #performance #monitoring

https://www.thatjeffsmith.com/archive/2021/03/creating-rest-apis-for-awr-with-ords-and-sql/
November 13, 2024 at 3:04 PM
Slides summing up what we've already documented and blogged for handling errors in your @OracleREST APIs

https://speakerdeck.com/thatjeffsmith/managing-error-messages-with-your-oracle-database-rest-apis
Managing Error Messages with your Oracle Database REST APIs
Your APIs call SQL or PL/SQL routines in the Oracle Datab...
speakerdeck.com
November 13, 2024 at 6:47 AM
Wondering why @OracleREST is acting the way it is...or isn't? It's probably something CONFIG related.

A MUST-READ post from our ords pm @chrishoina
https://followthecoffee.com/ords-config-list-include-defaults-command/
The one ORDS command you NEED to know! – Follow the Coffee
followthecoffee.com
November 12, 2024 at 2:14 PM
Yesterday @OracleREST showed how you can generate links in your ORDS responses...here's another example

The "$whatever" tells ORDS that should be a linked resource for our collection item, in this case the contents of a JSON doc...

1/2

#oracle #database #rest
November 13, 2024 at 4:18 PM
ORDS release news -

@OracleREST and @OracleSQLDev Web 22.4 have finished rolling out across the @OracleCloud Autonomous @OracleDatabase fleet...

We release ORDS 22.4 on-premises right before Holiday Break.

We'll have a minor update (22.4.1) scheduled to drop in a few weeks.
November 13, 2024 at 3:37 AM
Asked this morning, hey does @OracleREST have anything to help with Data Pump

Yes!

Full example here
https://www.thatjeffsmith.com/archive/2019/05/data-pump-via-ords/
Data Pump via ORDS
Data Pump export some Oracle Database tables via our REST...
www.thatjeffsmith.com
November 12, 2024 at 6:39 PM
End of year @OracleREST sneak peek feature coming your way...

@OracleSQLDev Web: Show me when my jobs are going to be running over a period of time, AND show me how long they will take to run based on previous iterations.
November 13, 2024 at 10:10 AM
What @OracleREST 21.2 feature should I blog about next? Perhaps...
November 13, 2024 at 12:58 PM
Something you've been asking for a LONG time...a Best Practices Guide for REST APIs and your Database.

Here's my first draft of that very thing..with a very strong lean towards @OracleDatabase via @OracleREST

...
November 13, 2024 at 9:05 AM