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.
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.
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!
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!
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!