You’ll at some point need to use a DATE as a predicate to get an item or collection of items out of your Oracle Database REST APIs. Here’s our least favorite, yet most common example, HR.EMPLOYEES. HIRE_DATE – when did you start working here? Let’s build a RESTful Service that lets me pull ALL of the employees hired on a certain DAY. Step One: Define the Template Step Zero would be to define the module,…

In fairness, it’s really only 8 lines of code, but @krisrice is a fan of comments. Here’s the setup: I have a query I want to run, where I can dump out a BLOB column in my table to separate files. And I need to automate this.A customer, in not so many words, more or less Using the SCRIPT command in SQLcl SQLcl will let you run whatever SQL or PL/SQL you want. And it…

On June 25th, we’ll have another 6 hours of presentations accompanied by hands-on-labs to demonstrate how in a data-driven world, your applications can really transform your business or organization. No need to register in advance, but if you do, we’ll send you a Calendar appt so you don’t forget! The format is pretty simple. We’ll have an open Zoom call for 6 hours with a defined set of talks – so you can come in…