I felt stupid when I found a small tip for using sqlplus.
If you have a file containing SQL statements and SQL*Plus commands, you can specify this filename on command line after '@'.
What I learned is that it's OK to have space betwen '@' and filename.
$ sqlplus test/oracle @ blah.sql
SQL*Plus: Release 188.8.131.52.0 Production on Fri Feb 13 02:00:10 2015
This enables using filename completion function (Hit TAB) in shells like bash,PowerShell.
Had I learned this 10 years ago, I could have saved probably 1 hour cumulative.
Anyway, I thought this is a good opportunity to try 'Java' version of sqlplus and check
'tip-for-tip compatibility' with native version of sqlplus.
» SQLcl Commands: Info & Info+ – The New DESC?
new SQL*Plus-style command line interface
So, I just untar the stuff on Exadata and ran it. And my 1st compatibility test passed!
$ sqlcl/bin/sql test/oracle @ blah.sql
SQLcl: Release 4.1.0 Beta on Fri Feb 13 02:13:25 2015
Copyright (c) 1982, 2015, Oracle. All rights reserved.
Oracle Database 12c Enterprise Edition Release 184.108.40.206.0 - 64bit Production
My next compatibility check would be screen size or WINCH signal or STDIN handling
and I expect Java version will behave differently.