OracleREST's profile picture. 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

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

Have you heard? We now offer support for GraphQL queries! Docs: social.ora.cl/6016R6bNG

OracleREST's tweet image. Have you heard? We now offer support for GraphQL queries! 

Docs: social.ora.cl/6016R6bNG

ORDS - GET PUT POST DELETE your Oracle Database 님이 재게시함

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

krisrice's tweet image. @OracleREST TIP:  print all config name/values including defaults
>> config list --include-defaults

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 social.ora.cl/6016ugy5C


Our product manager talks about how to debug/fix pool issues when starting ORDS social.ora.cl/6019PUiD7 Is the account locked? Is the password correct, needs updating?


ORDS - GET PUT POST DELETE your Oracle Database 님이 재게시함

@OracleREST tip. When there is an "All connections in use" , the numbers in the brackets are the pool stats > docs.oracle.com/en/database/or…

krisrice's tweet image. @OracleREST tip.  When there is an "All connections in use" , the numbers in the brackets are the pool stats > docs.oracle.com/en/database/or…

ORDS - GET PUT POST DELETE your Oracle Database 님이 재게시함

New post! We've added support for PATCH requests on your JSON-Relational Duality Views in @OracleDatabase 23c via @OracleREST release 23.2 thatjeffsmith.com/archive/2023/0…


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! social.ora.cl/6017PRqAf

OracleREST's tweet image. 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!
 social.ora.cl/6017PRqAf

ORDS - GET PUT POST DELETE your Oracle Database 님이 재게시함

Can't start @OracleREST in standalone mode because port 8080 is already in use? Fix it... peterobrien.blog/2023/07/17/808…

pobalopalous's tweet image. Can't start @OracleREST in standalone mode because port 8080 is already in use? Fix it...
peterobrien.blog/2023/07/17/808…

ORDS - GET PUT POST DELETE your Oracle Database 님이 재게시함

New post! More on @OracleREST 23.2 - nicer looking, more functional HTML error response pages. thatjeffsmith.com/archive/2023/0… #oracle #database #developers


Recommended reading: Best Practices for developing REST APIs for Oracle Database (with ORDS) social.ora.cl/6013OAiox #oracle #developers #advice #database #restapis


Effective use of eTags - one of many tools for speedier, more responsive apps. ORDS can help! Here are 3 takes: cdivilly.wordpress.com/2014/10/31/ora… krisrice.io/2020-09-22-ORD… blog.cloudnueva.com/ords-etags

OracleREST's tweet image. Effective use of eTags - one of many tools for speedier, more responsive apps. 

ORDS can help! Here are 3 takes:
  cdivilly.wordpress.com/2014/10/31/ora…

 krisrice.io/2020-09-22-ORD…

 blog.cloudnueva.com/ords-etags

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


A look at running ORDS locally in your dev env running against your Oracle #Database in #Podman from our own @chrishoina followthecoffee.com/user-guide-ora…


ORDS - GET PUT POST DELETE your Oracle Database 님이 재게시함

From the archives: REST APIs and TABLE INSERTs: the Definitive Guide for Oracle thatjeffsmith.com/archive/2022/0…



ORDS - GET PUT POST DELETE your Oracle Database 님이 재게시함

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 followthecoffee.com/ords-post-requ…

thatjeffsmith's tweet image. 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

followthecoffee.com/ords-post-requ…

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.

OracleREST's tweet image. 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.
OracleREST's tweet image. 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.
OracleREST's tweet image. 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.

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: docs.oracle.com/en/database/or… #oracle #developer #restapi #database

OracleREST's tweet image. 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: docs.oracle.com/en/database/or… 

#oracle #developer #restapi #database

ORDS - GET PUT POST DELETE your Oracle Database 님이 재게시함

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

FriedholdMatz's tweet image. Test with AutoREST table from my ADW @OracleREST with @axios -
it works.

Loading...

Something went wrong.


Something went wrong.