This content has been marked as final. Show 7 replies
Do you have a solution to run multiple scripts continuosly, one after the other as one script.
Say I have file1.sql file2.sql, file3.sql.
I want to create a script run.sql, where this will run file1.sql,file2.sql,file3.sql one after other without any one running one after the other like follows:
run.sql should have
dbms_output.put_line(select sysdate from dual);
If I run run.sql all the three scripts should be executed successfully and then display the current time . All these files have update statements(50,000 updates each file).
Very urgetn. Can some one hlpe, please.
Thanks in advance.
user10737256 wrote:Not in SQL*PLUS. However, depernding on what Oracle version you are on you can use DBMS_SCHEDULER to run OS commands (including SQL*PLUS invocations). Scripts must be on the server for this to work
This is quite useful. Thanks.
Is there a way to run multiple sql scripts , simultaneously though.