Love the command line? Hate ugly, out-of-the-box formatting of your results?
You’re in luck, we have just the thing for you:
It offers the ability to auto-pretty up your SQL results to the screen.
Here’s a quick video overview of what that is, and how it works.
For those of you w/o access to YouTube
How do you get through your day w/o cat videos and Marvel Studios movie trailers?
Anyways, here’s a quick recap:
SET SQLFORMAT ANSICONSOLE
Add that to your login.sql
When you startup your SQLcl, your queries will go from…
Each page of results is measured for ‘best fit’. We can’t make your screen bigger, so this isn’t a silver bullet.
If you want to use ANSICONSOLE, don’t use the SQL*Plus Report formatting commands like COL – use one or the other, your choice.
And you have a few more formats you can use…
What’s now self-explanatory is the ‘delimited’ format which isn’t listed in the Help for reasons (bug!)