Home » SQL & PL/SQL » SQL & PL/SQL » Settings before Login
Settings before Login [message #189805] Sun, 27 August 2006 23:34 Go to next message
sam4all
Messages: 29
Registered: August 2006
Location: Bangalore
Junior Member
Hi,

I want to change my settings in Sql*Plus before Login.
After Login i want new settings such as set pagesize 1500 like

regards,
Sam
Re: Settings before Login [message #189806 is a reply to message #189805] Sun, 27 August 2006 23:42 Go to previous message
vikasg2006
Messages: 78
Registered: March 2006
Location: Dubai
Member
hy
its very simple.
simply in SQL prompt type
SQL> ED LOGIN.SQL
AFTER THAT WRITE ALL WHICH U WANTS FOR EXAMPLE
set serveroutput on
set serveroutput on size 20000
set line 9999
set array 1
set time on
set pagesize 14
SPOOL ON
finally save the file and exit. Next time when u login. all of the above settings will execute automatically OK

vikas gupta
Previous Topic: Noobish question on looping within a cursor (nested loops?)
Next Topic: ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view
Goto Forum:
  


Current Time: Sat Dec 03 17:48:58 CST 2016

Total time taken to generate the page: 0.04387 seconds