How do I pass parameters to an SQL file

This mini tip comes from my friend Guruswamy.

 

How do I pass parameters to a SQL-Script?

 

Well the answer is simple, simply separate them with a space. For example:

SQL> @script.sql parameter1 parameter2 parameter3

 

How do you access the parameters inside the SQL file?

Refer the parameters as &1, &2, and &3.