You have a new version of SQLcl to download this morning.
Lots and lots of bug fixes – again, thanks everyone in the community for providing feedback so we can make continuous improvements.
A few things of note:
Two New Commands
They do pretty much what you’d expect.
You’ll also notice something new on startup/connects if you’re using a ‘local’ LOGIN.SQL
What’s a ‘local’ LOGIN.SQL?
It’s a LOGIN.SQL file that we find in your current working directory when starting SQLcl and doing a CONNECT.
If we find one, we won’t run any SQL. But, we will let you run SET commands so you can get your prompt and DDL shaping settings all just the way you need for your script. You can override this security precaution by setting your SQL_PATH env var to include the ‘.’ directory – not something I’d recommend.
Yes, we support 12cR2. More than that, SQLcl is using a 12.2 JDBC driver by default.
And one of the things you can do in 12.2 is of course get more descriptive TABLE and COLUMN names.
Our insight feature supports that, as well.
Just Installed Oracle Database 12c Release 2?
Good news – SQLcl is already there!
— Tim Hall (@oraclebase) March 2, 2017
Of course, it’s already out of date with today’s update.
We’re able to update SQLcl and SQL Developer MUCH more frequently on OTN…not so much with core database and client distributions. It’ll be there if you need it, but you might want to check OTN for the latest updates and bug fixes.