Debugging the PL/SQL you run from your APEX apps, from Oracle SQL Developer. Slides!
We’re bringing a day of Oracle Database fundamentals training to KScope 19 in Seattle on Sunday, June 23rd – don’t miss it!
What you need to know about licensing for Oracle SQL Developer and the Oracle JDK – hint: you’re covered!
Oracle REST Data Services version 19.1 is now available, and now provides a database management REST API for your Oracle Database.
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…
Using Excel to interface with your data in an Oracle Database using ORDS RESTful Services on your TABLEs.
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.
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.