We updated the Early Adopter offering of SQLcl today.
But first, I’m assuming you’ve heard of SQLcl? If not –
We’ve put in a ton of enhancements and even more bug fixes.
And Kris showed off a new feature today that mimic’s our SQL Developer grid preference for displaying NULL ‘values’…
— krisrice (@krisrice) June 16, 2015
But what I want to talk about are the insight feature and the inline editor.
SQLcl HAS AN EDITOR BUILT-IN!
Yes, you can still call the ‘edit’ command, and bring up Notepad or vi, both defaults for Windows and *NIX.
Or you can set it to ‘inline’ and it will just launch the same editor you see when you try to arrow through the buffer of a statement you’re currently typing or have pasted in.
Some HELP might be in order at this point:
So in my login.sql, I have this:
SET sqlprompt "_user '@' _connect_identifier >" SET sqlformat ansiconsole define _EDITOR=inline SET pagesize 25
Also, did you notice the bit about the Ctrl key sequences while editing in the inline editor?
Do you remember PC games from the 80’s? Up was always W, down was always S, and so on. Well that works now too. And at any time you want to just execute what you have in the editor, you have a hotkey for that too.
Let’s see a quick demo.
Expect lots and lots and lots of DEMO and some free stickers at KScope15 next week from Kris and I.