How to Run Oracle SQL Script from Command Line in Windows?

How to Run Oracle SQL Script from Command Line in Windows?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • SQL
  • 2 mins read

In this tutorial, you will learn how to run Oracle SQL Script (SQL*PLUS) from the command line in Windows.

Make sure that the Windows PATH variable already set for the  Oracle Database Home, for example, F:\app\Administrator\product\11.2.0\dbhome_1\BIN. Because if the PATH set in the variable, then you would be able to run the SQL*PLUS script from any folder.

Run Oracle SQL Script from Command Line in Windows Example

To run the SQL script, follow these steps:

  1. Open the command prompt by pressing the key Window+R and then type CMD in the Run window and press enter.
  2. In the Windows command prompt, change the directory where your SQL script exists, for example, CD F:\mysqlscripts and press enter.
  3. In your scripts folder, type the following command to run the SQL script:
sqlplus username/psw@orcl @your_script.sql

To run the script with parameters, for example, you want to pass the employee number 7852 and the employee name SCOTT to the SQL script, below is the example:

sqlplus username/psw@orcl @extract_employees_record.sql 7852 SCOTT

If the PATH variable not set for Oracle Home, then you can run the script by providing your Oracle database home path, for example:

F:\app\Administrator\product\11.2.0\dbhome_1\BIN\sqlplus username/psw@orcl @extract_employees_record.sql 7852 SCOTT

If the SQL script is not in the current directory, then you have to give the path for the SQL script too, for example:

F:\app\Administrator\product\11.2.0\dbhome_1\BIN\sqlplus username/psw@orcl @C:\emp_folder\extract_employees_record.sql 7852 SCOTT

In the above case, you can run the SQLPLUS command from any folder, and also can run the SQL script from any folder because you are providing the path.

You can also run the SQL script directly in SQL*PLUS, to do this follow these steps:

  1. Open SQL*PLUS and connect to the database.
  2. In the SQL command prompt, type the following command to run the script, for example, you want to run the emp_record.sql script from the C:\myscripts\ folder:
@C:\myscripts\emp_record.sql

See also: