How do I run multiple SQL files in UNIX shell script?

3 Answers. You can run a file in SQLPlus by using the @filename. sql notation. modify above script as per your db and requirements.

How do I run a SQL query in Unix shell script?

To run a SQL script using SQL*Plus, place the SQL along with any SQL*Plus commands in a file and save it on your operating system. For example, save the following script in a file called “C:emp. sql”. CONNECT scott/tiger SPOOL C:emp.