Thursday, October 15, 2015

SQLCL - Blob loading ALL the files

The github repo for all the things the DB Tools team does will be posted here https://github.com/oracle/Oracle_DB_Tools This will include sqlcl , sqldev, modeler, ords , and who knows what other things we have up our sleeves to post. This repo is going to be made up of examples and getting started things like a new extention for sqldev, custom transformation for modeler, ords integration with handsontable, or sqlcl scripting.

There's a new function in there to exec host commands and capture the stdout, stderr, and return code of the command. Now coupling that with the BLOB loading and you can load an entire directory of files into a table with a small amount of javascript.