SQL Plus command line: Arrow keys not giving previous commands back

[tech291083]

Hi,

I am using Oracle 10g Express Edition on Fedora core 5 32+ bit os. The problem is when I use the SQL Plus command line to make SQL statements I can not get the previously typed command back at the prompt when I use the up and down arrow keys on my keyboard. This is quite easy when I am using a shell, but here with this Oracle command line interface it is not working at all. Here is the example as what actually is happening whe I press the up or down arrow keys.

SQL> drop table mailorders;

Table dropped.

SQL> ^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A


Any suggestions ? Thanks............

[offcenter77]

This is not a feature of SQL Plus. The buffer only holds the current command, but has no history.

[tech291083]

Originally Posted by offcenter77

This is not a feature of SQL Plus. The buffer only holds the current command, but has no history.

Thanks mate.

[Shakes]

You may already know this but "/" does the last command and "edit" opens the last command for editing, so you can change it and save it, then run the modified command.

Cheers

[opasveer]

Before starting SQL Plus be sure to do 'export EDITOR=vi' This ensures that vi is used as an editor.

Also, when on the command editing is possible:
SQL> l => gives listing of command
SQL> l2 => lists line 2
SQL> c/abc/def/ => substitute abc by def
SQL> a text => append text to current (or last) line

[tech291083]

Originally Posted by opasveer

Before starting SQL Plus be sure to do 'export EDITOR=vi' This ensures that vi is used as an editor.

Also, when on the command editing is possible:
SQL> l => gives listing of command
SQL> l2 => lists line 2
SQL> c/abc/def/ => substitute abc by def
SQL> a text => append text to current (or last) line

Brilliant, thanks a lot.

[sej7278]

if you use gqlplus instead of sqlplus, you get bash-like history and completion (kinda cool pressing tab and getting table names completed!)

there is a way to get history using sqlplus, something to do with the termtype i think, if you don't want to use an editor.

[tech291083]

Originally Posted by sej7278

if you use gqlplus instead of sqlplus, you get bash-like history and completion (kinda cool pressing tab and getting table names completed!)

there is a way to get history using sqlplus, something to do with the termtype i think, if you don't want to use an editor.

Thanks very much....