save sqlplus setting and restore settings.
hello all,
how do i store display setting for certain sqlplus session and reset it back to wat it was....
so lets say i login to a sqlplus session
sqlplus scott/tiger@orcl
set lines 500
set pages 999
select * from emp;
exit;
now my question is, as i am changin all those setting (and obviously they defaulted to something to begin with...lets say lines to 80 and pages to 100)...how do i store that thing to begin with and then change my setting to lines 500 etc...and then once i am done before exiting restore the settings....