Can you deliver REST APIs for Oracle Database that work with XML using Oracle REST Data Services? Yes, yes, and yes! Here’ how with a few examples.
A brand new editing experience for Oracle Autonomous Database users, SQL or JSON, is now available in Database Actions, aka SQL Developer Web.
Join us on April the 29th as we take you on an adventure with your JSON data in an Oracle Database.
Do you want want to stay pure SQL, or try out our JSON Document Store?
Examples, demonstrations, and sample code for all of the different ways to work with REFCURSORs in your PL/SQL code and Oracle REST Data Services (ORDS).
You can now quickly assign storage quota on your new user’s default tablespace using Database Actions in your Oracle Database.
A beer themed take on Oracle REST Data Services (ORDS) – building RESTful Web Services based on my personal beer diary (Untappd).
You have stored or generated some bits that you want to stream down to your web client from your Oracle Database. And while ORDS likes to format things as JSON for you, you really don’t want that to happen in this case. Here, I have ALREADY handled the output processing via my SQL, I just wants ORDS to pass it down DIRECTLY to the client. When you define your HTTP (GET) handler as a ‘Media…
How to get list of snaphshots, links to AWR reports, & generating the HTML for those Automatic Workload Repository reports in Oracle Database using ORDS.
If you wanted to write some RESTful Web Services for Oracle to deal with BLOBs in an Oracle TABLE, and those BLOBs happened to be JSON documents, this is what that could look like.
A quick but important update for working with your database tools in Oracle Autonomous Database in the Oracle Cloud.
Everything you need to get debugging your PL/SQL using Oracle SQL Developer in your Oracle Autonomous Database…plus a GIF!
Some examples for sorting the results of your JSON Document Store Query By Examples using Oracle SQL Developer Web.
Got this question today and realized I didn’t really have a specific blog post that shows how to do that, so here we go! First things first, we need to go back and talk about the logical vs relational vs physical models again in SQL Developer Data Modeler. Logical Model – entities and attributes. We’re describing our data and how things are related. There are no tables yet. ERDs come from here. Relational Model -…