Navegando por ahi me he topado con el SQLcl, lo que sin duda substituirá al sqlplus

Entre las cosas que ofrece está:

• In-Line Editor- edit multi-line statements and scripts interactively at the SQLcl prompt
• Command History – cycle through your 100 previous scripts/commands
• Completion Insight – auto-complete object names or keywords using the tab key
• New Commands – CTAS, DLL, Repeat, ALIAS, SCRIPT, FORMAT, and many more!
• Client Side Scripting – execute javascript to manipulate query results, build dynamic commands, interact with the session, and much more

Aqui podemos ver un vídeo de como funciona !!en mac!!

Podemos descargarla de SQLcl en Oacle