Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to reset SQL*Plus env variables to default

Re: How to reset SQL*Plus env variables to default

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 19 Feb 2001 21:00:13 +0100
Message-ID: <t92umfe59dnr04@beta-news.demon.nl>

<sunk_at_focushope.edu> wrote in message news:96rr7d01kg0_at_news2.newsguy.com...
>
>
> Does anyone know how I can reset SQL*Plus env varialbles to default after
 the scripts have change them,
> eg pagesize, serveroutput, feedback...(exit and re-enter is not an option)
>
> Thanks in advance, Kurt.
>
> ==================================
> Posted via http://nodevice.com
> Linux Programmer's Site

Make sure your defaults are in a file called login.sql and just
@login.sql

Hth,

Sybrand Bakker, Oracle DBA Received on Mon Feb 19 2001 - 14:00:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US