Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQLPLUS $PATH ???
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