You can now define if your Oracle connections are THICK or THIN in version 19.1 of Oracle SQL Developer.
My wife and I are celebrating 20 years married (to each other!!!) , and I will not be here answering questions or posting new content for the next two weeks. However, there is a LOT scheduled to happen in the database tools world while I’m out. So be sure to follow @krisrice for news and updates. Oh, and if you like to torture yourself by watching others having fun, you can find me pretty easily…
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.
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.
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, organized by subprogram callsAccounts for SQL and PL/SQL execution times separatelyMakes me feel like an idiot whenever I try to…
How to get Oracle SQLcl to generate the DDL for an Oracle USER account.
When building your RESTful (Web) Services in ORDS, you assign a ‘Source Type’ for your handlers. The selection you make here has a big impact on how ORDS formats the response. In general, you give us some SQL or PL/SQL. We execute it, get the response, and turn it into {JSON}. It’s a bit more complicated than that though, so I wanted to walk through ALL of the different Source Types. Collection Query We expect…