Re: SQLPlus for windows

On Sat, 24 Mar 2001 20:00:13 +0100, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>
>"Frank Heijmans" <no_ftgh_at_xs4all.nl_spam> wrote in message
>news:ikppbtophiirr5gj6j1lgqvr59fbv31jii_at_4ax.com...
>> Hello,
>>
>> How can I keep environment settings in SQLplus, like linesize. I know
>> this should be possible since I've already seen it somewhere.
>> I am using 8.0.6 .0.0 for win95/98.
>>
 

>
>Create a file login.sql in your working directory.
>If you want to have them set globally, edit the file glogin.sql which is
>located in different directories on different platforms, and I currently
>don't remember the exact location. But as this is a documented issue anyway,
>you would best find the location of glogin.sql yourself.
>
>Regards,
>
>Sybrand Bakker, Oracle DBA

First of all, thanks for your reply.

I know this already, and it is not what I mean. When you change the screen buffer width f.i., it get's stored automatically, and I'm pretty sure this also should work with the set options.

When I use "set linesize 500" in glogin.sql nothing happens, but when I use the same syntax in login.sql it does work. I know glogin is executed correctly since I tested it. It is not very convenient if you have to set it in login.sql since there are many working directories in use and everyone would need a login.sql.

Cheers,

Frank Received on Sat Mar 24 2001 - 15:01:07 CST