$ cat sql_scripts.sql
select * from departments where location_id = 14000;
quit
$

$ sqlplus hr/hr @sql_scripts.sql

SQL> @sql_scripts.sql

# Name of this file : batch_sqlplus.sh
# Conunt employees and give raise.
sqlplus hr/hr <<EOF
select count(1) from employees;
update employees set salary = salary*1.10;
commit;
quit
EOF
exit