When you AUTO-REST enable table in ORDS, we publish a full API for you: We auto find your Primary Key Column and use that to address particular rows (items) in your table (collection.) But..what happens if you don’t have a primary key? CREATE TABLE no_keys (letter CHAR(1), letters VARCHAR2(25), numbers INTEGER); INSERT INTO no_keys VALUES (’a’, ‘abc’, 1); INSERT …
AUTO vs ‘Bespoke’ REST Services
The Automatic REST features in ORDS are very handy for getting started quickly with providing REST APIs to your data and stored procedures. Give me the data for an employee. Easy. REST enable the schema. REST enable the table. DO a GET on /ords/schema/table/id. But…I don’t want a ‘null’ in my JSON collection for value pair “commission_pct.” What’s an Oracle …
Oracle REST Data Services: GitHub all the Examples
You can now file bugs, sorry – submit Issues, for me on GitHub 🙂 What We’re Doing The intent is to build a nice library of How-To’s for ORDS. I’ve started with a section on PARAMETERS. ords-demo-parameters Build scripts to demonstrate working with parameters in your Oracle REST Data Services (ORDS) RESTful Services. This will demonstrate how to: Read a …
Querying the Oracle REST Data Services for your Oracle Database
So you’ve installed ORDS, you’ve REST enabled a schema, and you’ve started publishing some RESTful Services. Now, how do we go about seeing what’s what? You could browse… You could search… Or you could query the data dictionary! I’m going to look at USER_ORDS…stuff. We have _MODULES, _TEMPLATES, and _HANDLERS – most of what you’ll want is there. SELECT name, …
Yet Another REST POST (and GET!): BLOBs
I wrote recently about using REST to upload a file to your table with ORDS. I want to extend that and share more code. I want you to see how to not only load the pics, but then how to get a collection of items, with links to those items, and in this case, also links to the media (pics) …
POST Up a BLOB to an Oracle Table via REST
It seems kind of weird to do a blog post around a feature that’s fairly well documented, but this came up twice this week, so I figured I’d throw it out there. Scenario: I want to post up a record to be inserted into a table. The record will consist of a couple of regular values, but also a file, …
Bulk Load an Oracle Table from CSV via REST
I have 1,500 rows I need to shove into a table. I don’t have access to the database, directly. But my DBA is happy to give me a HTTPS entry point to my data. What do I do? Let’s look at a Low-Code solution: Oracle REST Data Services & Auto REST for tables. With this feature, you can say for …
ORDS: Returning Raw {JSON}
ORDS is nice. It auto-formats your SQL or PL/SQL results and response to JSON before returning to your client or application. But what if you’re response is ALREADY in JSON? Like this: Bad ORDS trying to convert JSON to JSON Good You telling ORDS we’re not just dealing with a CLOB, it’s actually JSON. Here’s that media post… The Media …
SQLcl and the the ORDS JDBC Driver
You know what SQLcl is. You know what ORDS is. How do those two things go together? Well, in ORDS 17.3 (Early Adopter/BETA!), we offer a new feature that allows you to execute ad hoc SQL and SQL scripts via HTTPS POST calls to ORDS. No access to the database via the Listener required. Wanna play? Maybe the easiest way …
Swagger Doc for ORDS RESTful Services
We’ve just released version 17.3 of Oracle REST Data Services – as an Early Adopter (BETA). Go Download ORDS 17.3 Now. There are 2 major new features, and this post is about one of those: Swagger/OpenAPI style JSON for /metadata_catalog/ calls. Wait, why should I care about REST? The Movie Screenshots for Those that Can’t do YouTube at Work It’s …