booksplus
asked on
Sqlplus - saving environment options from session to session
I want to be able to set the linesize and set the wordwrap and then have the settings saved from session to session.
When I set the environment options, the setting reverts back after I close SQLPLUS and open a new SQLPLUS window.
How do I save my settings from session to session. OR how do I open the SQLPLUS with my preferred options (command line options?).
Thanks.
When I set the environment options, the setting reverts back after I close SQLPLUS and open a new SQLPLUS window.
How do I save my settings from session to session. OR how do I open the SQLPLUS with my preferred options (command line options?).
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Target should look like: C:\oracle\ora92\bin\sqlplu s.exe <your_user_id>/<your_passw ord>@<data base> @commands.txt
Hope this helps!
Hope this helps!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
How do I enter the commands in the file -
I want linesize to be 130 and word wrap turned off.
I want linesize to be 130 and word wrap turned off.
exactly as you would enter it from the 'SQL>' prompt. Place each entry on its own line.
i.e./
contents of login.sql
========================== ==
set lines 130
set pages 100
...
i.e./
contents of login.sql
==========================
set lines 130
set pages 100
...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
They will be active each time you log in. The only gotcha is that depending on your O/S, you may have to execute your login.sql file each time you connect as another user in the same sqlplus session.