Oracle REST Data Services

Today’s video is a quick run through SQL Developer Web, introduced in Oracle REST Data Services (ORDS) 19.4.

For those that prefer the written word, this is based on the following article.

• Oracle REST Data Services (ORDS) : SQL Developer Web

You can find all my other ORDS content here.

In today’s video we’ll demonstrate how to include hyperlinks in JSON output delivered by Oracle REST Data Services (ORDS).

This is based on this article, which includes some more complete examples.

• Oracle REST Data Services (ORDS) : Including Hyperlinks in JSON Output

Good API design is not as simple as you might think, and making sure you pass back relevant information, like URLs for navigating through the services and maybe even service documentation links can make things a lot clearer.

https://oracle-base.com/blog/wp-content/uploads/2019/12/ords-2-258x300.png 258w" sizes="(max-width: 238px) 85vw, 238px" />

Almost 2 weeks ago I wrote about the release of Oracle REST Data Services (ORDS), SQLcl, SQL Developer and SQL Developer Data Modeler 19.4.

I spent the holidays playing around with ORDS quite a bit, so I came back to work today and pushed it out across all Dev and Test installations.

In today’s video we do a quick run through how to use HTTP headers and ORDS-specific bind variables in Oracle REST Data Services.

The video is based on this article.

• Oracle REST Data Services (ORDS) : HTTP Headers (OWA_UTIL) and ORDS-Specific Bind Variables

As always you can see all my ORDS articles here.

If you follow me, Jeff or Kris on Twitter, you will already know ORDS, SQLcl, SQL Developer and SQL Developer Data Modeler version 19.4 have all been released. They became available for download late Friday US time, and I got a DM about it yesterday morning, so fresh from spending 2 days running Data Guard builds, I moved on to running builds of some of this stuff.

Oracle REST Data Services (ORDS)

https://oracle-base.com/blog/wp-content/uploads/2019/12/ords-2-258x300.png 258w" sizes="(max-width: 139px) 85vw, 139px" />

It was a long day, but this is what I did.

In today’s video we’ll demonstrate the ORDS functionality built into Oracle SQLcl.

This is based on this article.

• Oracle REST Data Services (ORDS) : Use SQLcl to Display ORDS Web Service Definitions

There are loads of other ORDS articles here.

• Oracle REST Data Services (ORDS) : All Articles

The star of today’s video is Arman Sharma, captured at Sangam 2015. Seems like yesterday.

Cheers

In today’s video we look at the OAuth Implicit flow for Oracle REST Data Services.

This goes together with a previous video about first-party authentication here.

Both videos are based on parts of this article.

• Oracle REST Data Services (ORDS) : Authentication

There are loads of other ORDS articles here.

Today’s video is a run through the Database Authentication functionality in Oracle REST Data Services (ORDS).

As always, this is based on an article on the same subject.

• Oracle REST Data Services (ORDS) : Database Authentication

There are better methods of authentication and authorization available from ORDS, which you can read about here.

Today’s video is a run through the REST Enabled SQL functionality in Oracle REST Data Services (ORDS).

I wasn’t originally planning on doing this video yet, but the subject of REST Enabled SQL came up a couple of times in the last few days, so I thought I would alter my schedule.

This video is based on the following article, where you can find a lot more examples than are present in the video.

• Oracle REST Data Services (ORDS) : REST Enabled SQL

There is a lot more information about ORDS generally in these articles.

In today’s video we demonstrate first party cookie-based authentication, or basic authentication, for Oracle REST Data Services when run on Tomcat.

For those of you that prefer to read, this is one of the authentication and authorization methods discussed in this article.

• Oracle REST Data Services (ORDS) : Authentication

You can get more information about ORDS here.