Below you'll find a list of all posts that have been tagged as “ORDS”
I have a RESTful Service that accepts a bind value to a query that ORDS will run for me. How do I pass that bind to ORDS? You can do it explicitly be defining it as part of the URI. Or, you can use the classic web ?var=value to pass it. ORDS supports both 🙂 The only difference is the …
Let’s say you have some files, stored as BLOBs, in your database, and you want to make them available via REST. So of course you install Oracle REST Data Services, and now you have two options: REST Enable the table or Deploy a custom RESTful service With the first option, I get an ‘automatic’ REST endpoint for my resource, which …
One of the coolest features of Oracle REST Data Services v3.0 and higher, is the ability to REST enable your Oracle tables and views. You get a full REST api on your table – INSERT, UPDATE, DELETE, Select with or without predicates and sorting, and getting metadata. You can also batch load records. I’ve talked about the SELECT and GET …
Want to publish some RESTful services using SQL Developer and Oracle REST Data Services (ORDS)? You’re in luck! View > REST Data Services > Development. Before you can do this, a few things. you’ll need to install and run ORDS you’ll need to REST enable a schema you’ll need to have created an ORDS user with the ‘SQL Developer’ role …
In a previous episode, I showed how quickly you can REST enable your Oracle Database tables and views. And I took a second or 3 to show how to create a module in SQL Developer’s REST Development panel, which allows you to have a RESTful endpoint served by a SQL statement which will bring your data back as JSON. Today …
REST. Or, Representational State Transfer. It makes a lot of the INTERNET today possible. When you see an application making PUT or GET requests over HTTP or HTTPS, that COULD be REST. REST is an architectural style. You perform actions (GET, PUT, POST, DELETE) against resources, like a TABLE. So you do GET on employees. Or you do a POST …