I was going to talk about our new IMPORT command in SQLcl. This will allow you to feed a delimited text file of data to our command line interface and have it automatically imported to a table.
But Kris Rice beat me to it. Woo-hoo, less work for me 🙂
If you read far enough, you’ll see a really cool video on how to create a session monitor in SQLcl.
By the way, we updated it, and have a new EA build for you to play with. DOWNLOAD IT NOW
I’m going to show a simpler example – just a timer using SYSTIMESTAMP.
SET sqlformat ansiconsole SELECT systimestamp FROM dual; repeat 15 0.55
And you’ll get this.
Pretty cool, huh?
Just run your query – that will put it into the buffer. As in, if I hit ‘/’ – it will run again.
You can also put a query into the buffer using the history command.
Saying ‘history 2’ would put the 2nd item in your SQL History into the buffer.
Then run the repeat command.