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 …
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) …
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 …
SQL Developer 17.2: Publish RESTful Service (GET) based on a Data Grid
Think building REST Services for Oracle Database is hard? Tooling around SQL Developer, browsing data, and thought to yourself, that would make a great Web Service? Now, you can quickly publish the query behind a grid to a new or existing ORDS Module. Just right-click! (well wait a second, you need ORDS installed and configured for your database. And the …
Upcoming Webcasts: Getting Started with SQL Developer, SQLcl, & ORDS
I get the impression that many of you have thought about getting more acquainted with our development tools and platforms here at Oracle. But I ALSO get the impression that many of you just haven’t had the time. So, I’m officially inviting you to participate in a series of upcoming webinars I’ll be hosting. How they ‘work’ We’ll use a …