ORDS - GET PUT POST DELETE your Oracle Database@OracleREST
27 Nov 2023
Have you heard? We now offer support for GraphQL queries!

Docs: social.ora.cl/6016R6bNG
GraphQL query for Oracle - top 5 paid employees per department { locations { city departments_location_id { department_name employees_department_id(sort : [ { salary : "desc" } ], limit:5 ) { first_name last_name salary } } } }
0
3
9
1,678
ORDS - GET PUT POST DELETE your Oracle Database retweeted
krisrice 🏒🍺📷
@krisrice
16 Nov 2023
Replying to @OracleREST
@OracleREST TIP: print all config name/values including defaults
>> config list --include-defaults
1
4
15
1,820
ORDS - GET PUT POST DELETE your Oracle Database@OracleREST
26 Oct 2023
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
0
6
11
2,281
ORDS - GET PUT POST DELETE your Oracle Database@OracleREST
25 Aug 2023
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?
0
2
7
1,437
ORDS - GET PUT POST DELETE your Oracle Database retweeted
krisrice 🏒🍺📷
@krisrice
25 Jul 2023
Replying to @OracleREST
@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…
0
2
7
1,160
ORDS - GET PUT POST DELETE your Oracle Database retweeted
that Jeff Smith
@thatjeffsmith
21 Jul 2023
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…
0
9
6
1,910
ORDS - GET PUT POST DELETE your Oracle Database@OracleREST
19 Jul 2023
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
0
11
41
6,836
ORDS - GET PUT POST DELETE your Oracle Database retweeted
Peter O'Brien@pobalopalous
17 Jul 2023
Can't start @OracleREST in standalone mode because port 8080 is already in use? Fix it...
peterobrien.blog/2023/07/17/808…
0
2
5
870
ORDS - GET PUT POST DELETE your Oracle Database retweeted
that Jeff Smith
@thatjeffsmith
5 Jul 2023
New post! More on @OracleREST 23.2 - nicer looking, more functional HTML error response pages.

thatjeffsmith.com/archive/2023/0…

#oracle #database #developers
0
7
13
1,685
ORDS - GET PUT POST DELETE your Oracle Database@OracleREST
20 Jun 2023
Recommended reading: Best Practices for developing REST APIs for Oracle Database (with ORDS)
social.ora.cl/6013OAiox

#oracle #developers #advice #database #restapis
0
7
12
1,670
ORDS - GET PUT POST DELETE your Oracle Database@OracleREST
6 Jun 2023
Great post from one of our Oracle Database web developer enthusiasts, @JonDixonUS

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

blog.cloudnueva.com/oci-api-gatewa…
0
4
26
1,645
ORDS - GET PUT POST DELETE your Oracle Database@OracleREST
1 Jun 2023
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
0
3
4
1,296
ORDS - GET PUT POST DELETE your Oracle Database@OracleREST
31 May 2023
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
0
2
5
696
ORDS - GET PUT POST DELETE your Oracle Database@OracleREST
30 May 2023
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…
0
2
3
1,144
ORDS - GET PUT POST DELETE your Oracle Database retweeted
that Jeff Smith
@thatjeffsmith
28 May 2023
From the archives: REST APIs and TABLE INSERTs: the Definitive Guide for Oracle thatjeffsmith.com/archive/2022/0…
0
6
12
1,912
ORDS - GET PUT POST DELETE your Oracle Database@OracleREST
26 May 2023
Build best REST APIs for your Oracle Database with help from these experts -

blog.cdivilly.com/tags/ords/

krisrice.io/archive/

peterobrien.blog

followthecoffee.com/tag/ords/

thatjeffsmith.com/oracle-databas…
0
4
13
2,669
ORDS - GET PUT POST DELETE your Oracle Database retweeted
that Jeff Smith
@thatjeffsmith
25 May 2023
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…
0
3
2
1,021
ORDS - GET PUT POST DELETE your Oracle Database@OracleREST
23 May 2023
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.
The definition and implementation of our POST REST API to add an employee to our EMPS tableCalling our POST REST API to add an EMP to our EMPS table, and the response which has a link to our new employee
If we follow the link from our 201 response, we can see the new employee that has been added to the system, or our EMPS table
0
2
6
2,037
ORDS - GET PUT POST DELETE your Oracle Database@OracleREST
22 May 2023
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
A sample REST API with GET handler to test your Oracle Database configuration with REST Data Services (ORDS), begin ORDS_METADATA.ORDS.create_service( p_module_name => 'day_zero', p_base_path => 'day0', p_pattern => 'greeting/', p_method => 'GET', p_source_type => 'json/item', p_source => 'select ''Hello!'' from dual', p_status => 'PUBLISHED', p_module_comments => 'see if we can create a module', p_template_comments => 'see if we can create a template', p_handler_comments => 'see if we can say Hello!'); COMMIT; END; /
0
3
6
1,037
ORDS - GET PUT POST DELETE your Oracle Database retweeted
Friedhold Matz
@FriedholdMatz
20 May 2023
Test with AutoREST table from my ADW @OracleREST with @axios -
it works.
0
1
3
867
Load more