Saving, Editing, and Running SQL Files in SQL*Plus

In this tutorial, you'll learn how to save, edit, and run an SQL file in SQL*Plus. Some of the SQL*Plus file commands are listed in the following table:

SQL*Plus Commands for File (letters and words in brackets are optional)

Let's take a look at some examples of using these SQL*Plus commands.

select empno, ename, job from emp
  where deptno = 30;

SAVE Command

Now the above command is in the SQL*Plus buffer. You can save the buffer contents to a file using the SAVE command as shown below:

SAVE F:\code\sqlplus\emp_query.sql

For Linux/Unix:

SAVE usr1/work/sqlplus/emp_query.sql

Output

Created file F:\code\sqlplus\emp_query.sql

GET Command

The next example uses the GET command to retrieve the contents of the emp_query.sql file.

 GET F:\code\sqlplus\emp_query.sql

Output

SQL> GET F:\code\sqlplus\emp_query.sql
  1  select empno, ename, job from emp
  2* where deptno = 30

Now you can run the above command by using the forward slash (/) as shown below:

/

Output

     EMPNO ENAME                          JOB
---------- ------------------------------ ---------
      7521 WARDs                          SALESMAN
      7654 MARTIN                         SALESMAN
      7698 BLAKE                          MANAGER
      7844 TURNER                         SALESMAN
      7900 JAMES                          CLERK

EDIT Command

You can use the EDIT command to edit the contents of the file as shown in the below example:

EDIT F:\code\sqlplus\emp_query.sql

To edit the contents of the SQL*Plus buffer, use the EDIT command without filename parameter.

EDIT

START/@ Command

The following examples use the START and @ command to load and run the contents of the F:\code\sqlplus\emp_query.sql file:

START F:\code\sqlplus\emp_query.sql

Output

     EMPNO ENAME                          JOB
---------- ------------------------------ ---------
      7521 WARDs                          SALESMAN
      7654 MARTIN                         SALESMAN
      7698 BLAKE                          MANAGER
      7844 TURNER                         SALESMAN
      7900 JAMES                          CLERK

You can also use the @ command to run the SQL file. Below is an example:

 @ F:\code\sqlplus\emp_query.sql

See also:

• SQL*PLUS Script Examples
• How to Install SQL*PLUS in Linux? (Ubuntu)