Sample Header Ad - 728x90

Pass multiples values to script into sqlplus in Oracle

0 votes
3 answers
2351 views
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