Re: sqlplus substitution variables
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: exriscer@xxxxxxxxx
- Date: Fri, 28 Dec 2007 21:58:28 -0800
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:
