Jeff recently said on his blog: "and we’re super close to 100% SQL*Plus support now."
Great! But since it's not 100% yet, may I suggest a lacking feature to be one of the first to pick up next?
In SQL*Plus the 'column' command has an option 'new_value' which enables you to put the value of a column, selected in a query, to be put into a variable.
(see below for example)
In sqlcl 'new_value' appears to be accepted as an option for 'column', since no syntax-error is reported.
It doesn't work however.
This is a shame.
I have quite a number of scripts utilizing this feature, and they do not work in sqlcl.
This is the main reason for me to keep going back to sql*plus.
Example sql*plus (12.1.0.2.0)
EVANROON@DEV>column my_schema new_value current_schema
EVANROON@DEV>select user my_schema from dual;
1 row selected.
EVANROON@DEV>select '¤t_schema' var_value from dual;
VAR_VALU
--------
EVANROON
1 row selected.
Example sqlcl (feb 18, 2016)
SQL> column my_schema new_value current_schema
SQL> select user my_schema from dual;
1 rows selected.
SQL> select '¤t_schema' var_value from dual;
Enter value for current_schema