Oracle DBA FAQ‎ > ‎

How can DBA pass operating system variables to sqlplus?

posted Sep 10, 2010, 1:31 PM by Sachchida Ojha
One can pass operating system variables to sqlplus using this syntax:
sqlplus username/password @cmdfile.sql var1 var2 var3
Parameter var1 will be mapped to SQL*Plus variable &1, var2 to &2, etc. Look at this example:
sqlplus scott/tiger @x.sql  '"test parameter"' dual
Where x.sql consists of:
select '&1' from &2;
exit 5;
Comments