Re: SQL*PLUS Replacement... please?

Ari Gordon-Schlosberg wrote:

> A relatively new user of Oracle 8.4 (on Solaris), coming in
> as a convert from MySql, I find SQL*PLUS to be very nasty; it's
> shell is terrible: no commandline editing, no history being the
> two biggest complaints that I have.
>
> I'm wondering if
>
> a) There's just some configuration (environment or otherwise)
> that I need to do make this software that much easier to use
>
> or
> b) failing a), a piece of software (preferably freeware) that
> acts as a front-end to SQL*PLUS or replaces it entirely.
>
> Responses via e-mail would be much appreciated. Thanks.
>
> --
> Ari Gordon-Schlosberg Neoglyphics Media Corporation
> Software Engineer Champaign, IL
> ====================================================

Hi.

STEPS may be:

-Edit by YourFavoriteEditor SQL file . E.g. result file name is test.sql
- Run it: sqlplus logname/password_at_yourDB @test or

When you are in SQLPLUS and wish to save your SQL statement , to do: SQL> save filename.sql
SQL> edit filename.sql

or by SQLPLUS internal functions,e.g.:

SQL> list
SQL> 1 select * from tab
SQL> c/*/tname
SQL> select tname from tab
SQL> a  where tabtype='TABLE'
SQL>select tname from tab where tabtype='TABLE'
SQL> r

and last useful command: SQL> help command

Good Luck, Dmitry. Received on Fri Aug 28 1998 - 12:09:15 CEST