use file as sql*plus input
Can I use a file as sql*plus input?
I have a query like below:
select * from employees
where deptno = &1
and job = &2
/
It will prompt me for the values of course.
I can execute it at the command line like below:
sql>@script.sql 10 salesrep
Is is possible to put the values in a file and call the script like below:
sql>@script.sql <filename>
Then this file could be in a directory in the OS and I can add any values to it.
thanks.