Because the code is shared amongst our Oracle database tools (SQL Developer, ORDS, SQLcl) – many of the features you love in one tool, work just as expected in the others.
Oracle REST Database Services (ORDS) makes the full power of the Oracle Converged Database available via the world’s most popular interface – HTTP(s).
Yes, yet another Tips & Tricks post for Oracle SQL Developer.
These are the most very basic tips (5) you need to know when getting started with Oracle’s #1 development, query, and administration tool.
A quick walk through of the enhancements for the LOAD command in Oracle SQLcl version 20.2.
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.