test.. pls ignore

hi all,

             test

> -----Original Message-----
> From: Jared Still [SMTP:jkstill_at_bcbso.com]
> Sent: Friday, April 28, 2000 9:15 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Parameters with spaces
>
>
> This works for me:
>
> sqlplus jkstill/PASSWORD_at_dv05 @x.sql "'this is a test parameter'"
>
> x.sql consists of:
>
> select '&1' from dual;
>
> Jared
>
> On Thu, 27 Apr 2000, Bill Becker wrote:
>
> > I know that you can pass env vars from unix to sqlplus via:
> > sqlplus name/password @file "$VAR1"
> >
> > In the called script, the value of $VAR1 can then be referenced
> > as '&1'. This works fine, except when $VAR1 is an expression containing
> > multiple strings separated by spaces; then '&1' is interpreted as
> > only the first string, up to the first space. The number of
> > strings in the expression is variable, and the '&1' is used in the
> > script in a WHERE clause: WHERE FIELD1 = '&1';
> >
> > Does anyone know of a way to pass an expression from the unix shell
> > to sqlplus, preserving all strings and spaces within the expression?
> >
> > On Solaris 2.7, Oracle 8.1.6
> >
> > Thanks to any who reply
> > beckerb_at_dgabby.mfldclin.edu
> > --
> > Author: Bill Becker
> > INET: beckerb_at_dgabby.mfldclin.edu
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
>
> Jared Still
> Certified Oracle DBA and Part Time Perl Evangelist ;-)
> Regence BlueCross BlueShield of Oregon
> jkstill_at_bcbso.com - Work - preferred address
> jkstill_at_teleport.com - private
>
>
> --
> Author: Jared Still
> INET: jkstill_at_bcbso.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon May 01 2000 - 08:24:26 CDT