Comfortable sqlplus interface

oraclesqlplustools

I found sqlplus'interface is rather outdated. It's quite nice to have some commands or keywords at disposal, but for example no "arrow-up" key for the previous history entry is available.

What is a good replacement / extension for sqlplus? Could be a GUI or better (so it stays useful via SSH) a command line utility.

SQL*Plus is the main command line tool to operate with the Oracle Database.

Best Answer

A very easy tweak is to add rlwrap.

Related Solutions

Differences with using Bind variables in TOAD,sqlplus and SqlDeveloper

In SQL*Plus and SQL Developer you need a / at the end of a PL/SQL block.

variable pStartDateBegin VARCHAR2(10);
variable pEndDateFinish VARCHAR2(10);

begin
      select '01-01-2000', '30-11-2011'

      into :pStartDateBegin,:pEndDateFinish
        from dual;


end;
/

[...]

Sqlplus not working on opensuse

sqlplus is not in your path.

Use su - oracle instead of su oracle, as that will read the users ~/.bash* files & set the environment accordingly.

Best Answer

Related Solutions

Differences with using Bind variables in TOAD,sqlplus and SqlDeveloper

Sqlplus not working on opensuse

Related Question