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: SQLPLUS $PATH ???

Re: SQLPLUS $PATH ???

From: change <changeme_at_changeme>
Date: Thu, 7 Dec 2000 17:48:51 -0500
Message-ID: <90p3fo$rs57@kcweb01.netnews.att.com>

What you need to do is to set SQLPATH environment variable which contains a list of directories to search when looking for a SQL script. export SQLPATH=$HOME
or
setenv SQLPATH $HOME if you use C shell.

Tony

"Feldman Roger" <qrarofe_at_era.ericsson.se> wrote in message news:3A2F655B.6191A5C4_at_era.ericsson.se...
> Oracle People:
>
> I've worked a lot with Unix and obviously understand that you can set
> the PATH so that unix knows where to look for executables. How do you
> set the PATH in SQLP
> LUS> so that I don't have to list the direct path to my *.sql scripts or
> place them in $ORACLE_HOME where SQLPLUS can currently execute them
> without the full pa
> th name ? $ORACLE_HOME is the only current place that sqlplus finds them
> without the full path.
>
> THANX-
>
> Roger
>
Received on Thu Dec 07 2000 - 16:48:51 CST

Original text of this message

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