Re: Configuring properties for SQL plus

Simon,

Take a look at glogin.sql and login.sql files. You can add settings in these files and they are read when you start up SQL*Plus. See:   

http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a90842/ch3.htm#1005624

You might also want to take a look at iSQL*Plus. iSQL*Plus is available with Oracle9i 9.0.1 for Windows, or Oracle9i 9.2.0 (most platforms).   

http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a90842/toc.htm

Alison

Simon Harvey wrote:

>Hi guys,
>
>Can anyone tell me what you need to do to make the changes that you might
>make to SQL plus permenant.
>
>For example, I always fing the linesize to small and always need to at least
>double it. Is there anyway that I can configure it to do this all the time
>as I'm sick of doing it each and every time.
>
>The other more basic thing is, does anyone have any recomendations for
>something that does the same sort of job as SQL plus but is better. I really
>hate SQL+. I dont get why oracle are still shipping that thing. It looks
>like it hasnt been changed in 15 years. (For example, why cant you move the
>cursor back along the line if you make a mistake. Instead it forces you to
>delete the entire line up to your mistake. What on earth is that about!)
>
>Anyway, I really need an open source solution. I'd love to buy something
>like SQL Navigator as I think that that is a really great product (and
>frankly for 25000 quid I'd expect something of that quality from oracle
>themselves).
>Unfortunately I'm just a student and so dont have any money to spend on
>expensive development software.
>Can anyone point me in the right direction.
>
>Thanks to anyone who can help
>
>Kind Regards
>
>Simon
>
>
>
>
Received on Thu Nov 28 2002 - 17:29:09 CST