I want to execute the same sql script passing one text every time but I don't know how to it. I want to do it into sqlplus.
With this select I have the values but I don't know how to pass this values.
select column_value from table(sys.dbms_debug_vc2coll('Logons Per Sec', 'Executions Per Sec')))
LOOP
start script.sql column_name;
END LOOP;
I don't understand your example. I have try to use but it doesn't works. I want to pass both values to "prueba.sql" (one in each execution)
cat prueba.sql
prompt &1;
SQL> COL column_value NEW_VALUE v_column_value
SQL> select column_value column_value from table(sys.dbms_debug_vc2coll('Logons Per Sec', 'Executions Per Sec'));
COLUMN_VALUE
--------------------------------------------
Logons Per Sec
Executions Per Sec
SQL> @prueba.sql &&v_column_value
Executions
I want to execute a report inside the prueba.sql each time with one of this values as parameter.
Thanks
Asked by estonolose
(95 rep)
Apr 9, 2017, 01:28 AM
Last activity: Oct 15, 2024, 07:01 PM
Last activity: Oct 15, 2024, 07:01 PM