Just because you’re in a command line interface doesn’t mean you’re stuck with ugly code!
Wait, if it’s my code, you’re stuck with ugly code.
But if it’s YOUR code, then you’re not stuck with poorly formatted code.
You can of course use the FORMAT command to format what’s in a file or in the SQLcl buffer.
I don’t like the formatter default settings!
Have no fear.
Load up the GUI.
Yes, THAT GUI.
Set your preferences.
Go back to SQLcl, load the formatter rules.
Before the format…
Ok, let’s format that.
Note I did with this the latest copy of SQLcl – updated just LAST WEEK – and a pre-production version of version 4.2 of SQL Developer which you folks will be able to get access to later this year.
Here’s SQLcl using formatter settings applied from EA2, so that SHOULD work for those of you using the EA.