sqlplus substitution variables

Hi

Writting some informix migration scripts here and just got a bit stucked.

When we invoke sql scripts in sqlplus with arguments such as

@test.sql par1 par2 par3

par1, 2 and 3 can be treated as &1, &2 and &3

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)

Thanks

--

LSC
--

http://www.freelists.org/webpage/oracle-l Received on Fri Dec 28 2007 - 12:27:48 CST