3 ms·
Possibly, but I’m still stuck automating using SQL*Plus. If it just had libreadline [CURSOR UP] history functionality, it would be really powerful (the official
by Annatar 9y ago
Possibly, but I’m still stuck automating using SQL*Plus. If it just had libreadline [CURSOR UP] history functionality, it would be really powerful (the official documentation on it is 600+ pages). pgsql and Vertica databases don’t need any more client enhancements, but the one database which does doesn’t get one. Talk about a missed market opportunity!
- barrkel 9y agoUse rlwrap as another commenter mentioned.
- oblio 9y agoYou're assuming that most DBA's or companies using Oracle would pay for more powerful CLI. In my experience with Oracle DBA's, most just use SQLDeveloper.
- Annatar 9y agoCan't use SQLDeveloper to automate, because you can't call a Java GUI to run SQL and PL/SQL code inside of an OS package postinstall since it has to run in a headless environment. And if you're automating that way, you want a powerful command line SQL client while you're automating, otherwise it's a pain in the ass to switch back and forth.