Is there a way using Collection Query to return a list of numbers as a JSON array using Oracle REST Data Services for my REST API?
The answer is, YES!
How to setup and configure your editor look and feels in Oracle Database Actions (SQL Developer Web), plus a quick tour of the Command Palette.
I’ve talked about trapping PL/SQL Exceptions in your REST APIs before – you can catch up on that here. But, you can stay RIGHT HERE – this post covers the same material, just in more detail. Got a question from someone new to ORDS, let’s pretend their name is ‘Kartik.’ They wanted help figuring out why their ORDS Exception block wasn’t properly setting the Response Header STATUS code, in this case a 400. Let’s look…
How to debug and diagnose those pesky errors in your REST APIs with ORDS – print errors to screen, correlate HTTP errors to the SQL in your DB and more.
Why isn’t there a COMMIT or ROLLBACK button in the SQL worksheet in Database Actions (Oracle SQL Developer Web.)
Quick update – we put out updates with bug fixes for both SQLcl and SQL Developer version 21.2 yesterday. Time to go download (again!)
You can save and recall work in your online SQL worksheets with Database Actions. Plus a quick sneak-peek of some charting enhancements!
Video recording from my Oracle Global Leaders presentation last week on data modeling and design for Oracle Database.
I’ve published a new video tour of Oracle Database Actions (SQL Developer Web!)
I’ve included bookmarks so you can jump from topic to topic.
Oracle SQL Developer and Data Modeler versions 21.2 are now available! Bug fixes and a better experience on Mac await!
It’s now easier than ever to use SQL to interrogate your JSON Collections in an Oracle Database using the Database Actions web interface.
This 7 minute video tutorial will get you up to speed with your favorite Oracle Database tools to view and update your tables.
Creating INDEXES on our JSON (SODA) Collections is much easier in Database Actions version 21.2.
The REST development environment in Database Actions via ORDS version 21.2 now includes an integrated OpenAPI swagger user interface.
