Pass multiples values to script into sqlplus in Oracle
You can use COLUMN command in SQL*PLUS as shown below.

SQL&gt; COL column_value NEW_VALUE v_column_value
SQL&gt; select column_name column_value from table(sys.dbms_debug_vc2coll('Logons Per Sec', 'Executions Per Sec')));

SQL&gt; @"test.sql" &amp;&amp;v_column_value


Documentation: COLUMN in SQL*PLUS