Re: How to save SQLPlus session settings?

Set yourself up a login.sql file in your home directory (or possibly anywhere in your SQLPATH environment variable) with the setting s you want, e.g.,

set echo on
set pagesize 24
set timing on
etc.

One feature I like to use here are col definitions for columns that I use often in ad hoc queries:

col description format a35 word
col name format a15 word
set numformat 999,999,999.99

James Ching wrote in message <350219D6.7D359590_at_earthlink.net>...
>Can anyone tell me how I can save the settings I did by
>"alter session" and make them default settings?
>I'd like to have them automatically loaded everytime I use
>SQLPlus or SQLLoad.
>
>Thanks!
>
>
>James Ching
>EarthLink Network, Inc.
Received on Sun Mar 08 1998 - 00:00:00 CST