Detecting SQL injection in your PL/SQL with Oracle SQLcl, your modern command line interface for the Oracle Database.
Working with your Oracle Database in the Oracle Cloud is as easy as opening your browser – you can even open a shell prompt and start using SQLcl!
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).
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. 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, but the real work comes into play for…
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…
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!