Re: sqlplus substitution variables

On Dec 28, 2007 10:27 AM, LS Cheng <exriscer@xxxxxxxxx> 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

Other related posts: