How Do I Run Multiple Sql Queries in Unix Shell Script?
Contents

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.

James H. Sterling

James H. Sterling

Environmental Science & Climate Journalist

James Sterling reports on renewable energy developments, climate policy, ecological conservation, and green tech innovations around the globe.

Share this article
Twitter Facebook Pinterest