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,…
How to import your AVRO, JSON, and XML data into Oracle Database tables using Oracle SQL Developer Web.
With Oracle REST Data Services version 20.2, you have a TON of new end points available to help manage and monitor your Oracle Database. Here’s a quick tour.
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…
Oracle REST Data Services v20.2 is now available! Lots of bug fixes, a new look and feel (plus features!) for SQL Developer Web, more DB API management end points, and more!
Versions 20.2 of SQL Developer, SQL Developer Data Modeler, and SQLcl are now available! Here’s a quick summary/rundown of what to expect.
My TOP 10 Tips and Tricks for Oracle SQL Developer updated for 2020!
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…
Executing PL/SQL stored procedures via ORDS RESTful Services.
I want your ORDS success/happy/win stories!
You can code SQLcl script stuff INTO your Libquibase changeSets! Here’s an example using SPOOL and LOAD commands.
A quick look at a extension we provide as an example for writing your own Java plugins for SQL Developer – this visualizes object dependencies in your Oracle Database.
A few quick notes on setting breakpoint conditions in your PL/SQL debugger scenarios.
Oracle SQL Developer for the DBA slides and video.
Kris Rice and I’s slides from our ODTUG Learn at Home talks on Oracle REST Data Services (ORDS).