ORDS - GET PUT POST DELETE your Oracle Database

Oracle REST Data Services (ORDS) provides REST APIs for Oracle Database & the JSON Document Store (SODA) plus the Database Actions (SQL Developer Web) App.

[ORDS - GET PUT POST DELETE your Oracle Database @OracleREST]

Have you heard? We now offer support for GraphQL queries!

Docs: https://t.co/dhueOHHzvU

[krisrice 🏒🍺📷 @krisrice]

@OracleREST TIP: print all config name/values including defaults
>> config list --include-defaults

[ORDS - GET PUT POST DELETE your Oracle Database @OracleREST]

Join @chrishoina @thatjeffsmith on 14 November @ 12 PM ET ! We'll be teaching you how to make sure your Oracle Database REST APIs are FAST.

Topics will include tuning tips, ORDS features to minimize response times, and free testing tools.
Register TODAY https://t.co/Hxbfmr8Zxy

[ORDS - GET PUT POST DELETE your Oracle Database @OracleREST]

Our product manager talks about how to debug/fix pool issues when starting ORDS
https://t.co/HtUU2uNLWU

Is the account locked? Is the password correct, needs updating?

[krisrice 🏒🍺📷 @krisrice]

@OracleREST tip. When there is an "All connections in use" , the numbers in the brackets are the pool stats > https://t.co/tEYsh3fN02

[that Jeff Smith @thatjeffsmith]

New post! We've added support for PATCH requests on your JSON-Relational Duality Views in @OracleDatabase 23c via @OracleREST release 23.2

https://t.co/SUqQk9PmCI

[ORDS - GET PUT POST DELETE your Oracle Database @OracleREST]

Have you seen our new default landing page? 23.2 will make it easy for you to get started with SQL Developer Web and/or APEX for any of the databases you have enabled with #Oracle REST Data Services (ORDS)

Learn more and/or download the latest here!
https://t.co/1J7KuEMSER

[Peter O'Brien @pobalopalous]

Can't start @OracleREST in standalone mode because port 8080 is already in use? Fix it...
https://t.co/fhgBKvoH4g

[that Jeff Smith @thatjeffsmith]

New post! More on @OracleREST 23.2 - nicer looking, more functional HTML error response pages.

https://t.co/uRwZYfhrx2

#oracle #database #developers

[ORDS - GET PUT POST DELETE your Oracle Database @OracleREST]

Recommended reading: Best Practices for developing REST APIs for Oracle Database (with ORDS)
https://t.co/2aOX0oSQdy

#oracle #developers #advice #database #restapis

[ORDS - GET PUT POST DELETE your Oracle Database @OracleREST]

Great post from one of our Oracle Database web developer enthusiasts, @JonDixonUS

A must-read if you plan on deploying apps in @OracleCloud

https://t.co/3nEfHYM2yK

[ORDS - GET PUT POST DELETE your Oracle Database @OracleREST]

Effective use of eTags - one of many tools for speedier, more responsive apps.

ORDS can help! Here are 3 takes:
https://t.co/dH4dFZb4Q3

https://t.co/gq5F27OdTc

https://t.co/nudYWettEs

[ORDS - GET PUT POST DELETE your Oracle Database @OracleREST]

Exporting your REST APIs, Clients, objects for an entire schema OR

Exporting a single module OR

Generating OpenAPI client/doc for a module - using SQL Developer Web's REST interface!

#oracle #restapis #database #developer

[ORDS - GET PUT POST DELETE your Oracle Database @OracleREST]

A look at running ORDS locally in your dev env running against your Oracle #Database in #Podman from our own @chrishoina

https://t.co/TjtZCxrCxM

[that Jeff Smith @thatjeffsmith]

From the archives: REST APIs and TABLE INSERTs: the Definitive Guide for Oracle https://t.co/dOgZfxuGPy

[ORDS - GET PUT POST DELETE your Oracle Database @OracleREST]

Build best REST APIs for your Oracle Database with help from these experts -

https://t.co/geocbHTjKW

https://t.co/jV0bULfURF

https://t.co/e4TNPvkxfh

https://t.co/1BF5Pe264o

https://t.co/BaCiW6v0xJ

[that Jeff Smith @thatjeffsmith]

Great post where @chrishoina shows how to drag-and-drop CSV files on your Mac, and have the data automatically loaded to a table in your @OracleDatabase using REST APIs

https://t.co/519wX0nSkV

[ORDS - GET PUT POST DELETE your Oracle Database @OracleREST]

Calling REST APIs that do 'work' against your @OracleDatabase boils down to HTTP -> SQL/PLSQL -> HTTP with JSON being the data data-interchange format

So issuing a POST, results in a PL/SQL block being executed,

The response format/data is also defined here.

[ORDS - GET PUT POST DELETE your Oracle Database @OracleREST]

Need a 'Hello, World!' REST API to see if you've deployed ORDS correctly?

Here's a single block of PL/SQL to do that for one of your REST Enabled Schemas - see the image ALT text.

PL/SQL API Docs: https://t.co/h2SLmlJyb0

#oracle #developer #restapi #database

[Friedhold Matz @FriedholdMatz]

Test with AutoREST table from my ADW @OracleREST with @axios -
it works.