Re: sqlplus substitution variables

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 28 Dec 2007 21:58:28 -0800
Message-ID: <bf46380712282158n2dddcec5tb53d373ebcc87e9a@mail.gmail.com>

On Dec 28, 2007 10:27 AM, LS Cheng <exriscer_at_gmail.com> wrote:

> I have a situation where the number of arguments can vary so I can have
> from par1 only up to par3 inclusive.
>
> Basically does anyone know if there is something similar as $# in ksh but
> for SQLPLUS? Or anyway to treat do something like NVL('&2', ';') (this does
> not seem to work as it prompts and asks for a value)
>
>

At this point it would be advisable to use a shell script as a front end processor for the sqlplus script.

There may be a method to do you wish in sqlplus, but such workaround are often clumsy and difficult to maintain or modify.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 28 2007 - 23:58:28 CST