Run .sql files in sequence on sqlplus

Question

We have multiple .sql files and is there any way we can run them in single job ?

Sample files.

 @task1.sql ; 
 @task2.sql ; 
 @task3.sql ;

Is there any way can I put all 3 above files in single files and run?

Littlefoot · Accepted Answer · 2021-12-02 09:57:19Z

1

Well ... yes.

task_main.sql:

@task1.sql
@task2.sql

task1.sql:

select deptno, ename, job, sal
from emp
where deptno = 10;

task2.sql:

select * from dept;

Running task_main from SQL*Plus:

SQL> @task_main

    DEPTNO ENAME      JOB              SAL
---------- ---------- --------- ----------
        10 CLARK      MANAGER         2450
        10 KING       PRESIDENT       5000
        10 MILLER     CLERK           1300


    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON

SQL>

answered Dec 2, 2021 at 9:57

Littlefoot

144k15 gold badges41 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Run .sql files in sequence on sqlplus

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related