Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SQL-Script with arguments problem
Hi,
i call a sqlscipt with arguments in sqplus (unix). I start sqlplus with option -S[ilent]. The result of the query is written in a textfile: sqlplus -S username/password @script.sql 01.07.2001 01.08.2001 > textfile
content of script.sql:
select * from emp where hiredate between '&1' and '&2';
The problem is that not only the result of the query was written in the
textfile.
The following text was also written at the beginning at the textfile:
old 30: where hiredate between '&1' and '&2' new 30: where hiredate between '01.07.2001' and '01.08.2001'
How can i avoid this! I want that only the results of my query are standing in the textfile. Received on Wed Dec 19 2001 - 11:28:31 CST