Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Yet another tool for Command_line_history for Linux DBA

Re: Yet another tool for Command_line_history for Linux DBA

From: Egor Starostin <egorst_at_gmail.com>
Date: Wed, 12 Jan 2005 02:53:11 +0600
Message-ID: <f0fc9197050111125371ccd4cc@mail.gmail.com>


> Doing so on a SQL*Plus command line is less so. SQL statements
> are often more than one line, so it is necessary to up arrow to each
> line in succession, making sure it is the correct line, and then hit
> enter. Do this for each line in the statement.
Agree. I use rlwrap abilities to edit command line only for one-liners. For the others I use vim.

> It is simply to easy in SQL*Plus to save the buffer to a file via
> the 'save' command, or simply 'get afiedt.buf' and 'ed'.
What I like in rlwrap is it's ability for word completion. I.e. I created sql.dict file with sql keywords and words like dba_role_privs, etc. and run 'rlwrap -f sql.dict sqlplus'. After that, I type 'dba_ro' and press <tab> to complete it to dba_role_privs (the same way as in my vim editor).

-- 
Egor
http://www.oracledba.ru/orasrp/
Free Oracle Session Resource Profiler
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 11 2005 - 14:58:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US