Also, we took the sqlplus engine we have and built a command line for it and named it SDSQL. Someone will say this stands for sql developer sql but let's not dwell on names. This new command line has TONS of things in it. Please keep in mind this is an EA. The new command line is very very compatible with sqlplus in fact I alias sqlplus to my sdsql and that's all I use now. However, this is an EA and it is not 100% sqlplus and may never be there's some very odd old things that sqlplus does like did you know "SQL> #create table klr_1 ( id number );" works? Yeah , we're not doing that.
Anyway, grab it, try it, see what you think. On the 4.1 download page there's a section for SDSQL. Just grab that and as usual just unzip and ./sdsql. This screenshot shows color coding and a nice compact printing of the results of a query. This results is buffered and the col headers are set to the max of the datasize completely ignoring whatever your linesize is set to. The catch is only 5k rows is supported since it's buffering. Query over 5k and you'll get a nice warm message that says unsupported.
Here's my Login.sql if you want to try it out.
set sqlformat ansiconsole set sqlprompt '"@|red _USER|@@@|green _CONNECT_IDENTIFIER|@@|blue,bg_green,bold >|@"
If you want different colors, here's a script that shows a lot of the possibilities.
select '@|red,bold,underline This is red,bold,underline|@' "@|red Colors|@" from dual union all select '@|NEGATIVE_ON This is negative|@' from dual union all select '@|INTENSITY_FAINT This is faint|@' from dual union all select '@|INTENSITY_BOLD This is my bold|@' from dual union all select '@|ITALIC This is italic|@' from dual union all select '@|UNDERLINE This is underline|@' from dual union all select '@|BLINK_SLOW This is blink_slow|@' from dual union all select '@|BLINK_FAST This is blink_fast|@' from dual union all select '@|CONCEAL_ON This is conceal|@' from dual union all select '@|black This is black|@' from dual union all select '@|green This is green|@' from dual union all select '@|yellow This is yellow|@' from dual union all select '@|blue This is blue|@' from dual union all select '@|magenta This is magenta|@' from dual union all select '@|cyan This is cyan|@' from dual union all select '@|white This is white|@' from dual union all select '@|bg_red This is bg_red|@' from dual union all select '@|bg_black This is bg_black|@' from dual union all select '@|bg_green This is bg_green|@' from dual union all select '@|bg_yellow This is bg_yellow|@' from dual union all select '@|bg_blue This is bg_blue|@' from dual union all select '@|bg_magenta This is bg_magenta|@' from dual union all select '@|bg_cyan This is bg_cyan|@' from dual union all select '@|bg_white This is bg_white|@' from dual union all select '@|bg_red This is bg_red|@' from dual
And here's what you'll see from it.
