How to find the degree of parallelism for your queries in Oracle SQL Developer.
Your response for a GET on a collection vs collection item vary greatly, especially when what you’re asking for in ORDS does not exist.
See how Oracle SQL Developer can help you figure out which tables or views are causing your ORA-00942 errors.
How to make your PL/SQL functions available via HTTP using Oracle REST Data Services.
Sometimes you need to write some SQL to interact with your RESTful Service request bodies – here’s an example of going from nested JSON to a new record in a table using the JSON_TABLE function.
A quick overview of escaping our of edit mode in Oracle SQLcl and cancelling queries.
Oracle SQL Developer can help you with your PL/SQL calls, including the procedure or function argument assignments.
I have a PL/SQL block of code – I wonder where most of the time is being spent to execute it? Well guess what? The PL/SQL team has given us an interface to answer this exact question. The PL/SQL Hierarchical Profiler does 3 things of note: Reports the dynamic execution profile of your PL/SQL program, […]
Overview of how ORDS is deployed, and some new PowerPoint slides demonstrating the AUTO features versus coding your own RESTful Services.
How to get Oracle SQLcl to generate the DDL for an Oracle USER account.