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 -…
Taking an Oracle Database class or course? Need to get up and going on Oracle Database really fast, and really easily? Here’s my advice!
A quick look at loading data using DBMS_CLOUD and tracking what you’ve done with USER_LOAD_OPERATIONS.
What are the perfect set of formatting rules for your Oracle SQL and PL/SQL? The debate rages on, but here’s a look at the Trivadis group and their code standards.
Oracle SQL Developer version 20.4 is now available for download!
Quickly filter and browse the contents of your tables and views using the object viewers in Oracle SQL Developer Web (version 20.4).