Re: SQL*PLUS Replacement... please?

visit www.toad.com, very useful and easy to use

Dmitry G. Bezgodov <dima_at_profit.maginfo.net> wrote in article <35E681CB.451DD759_at_profit.maginfo.net>...
> 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
> ...executing SELECT...
> and so on.
>
> and last useful command: SQL> help command
>
> Good Luck, Dmitry.
>
>
>
Received on Tue Sep 01 1998 - 00:00:00 CDT