[Solved] Append instead of overwrite

Applications Programming
1

Hi,

I have a script which append the .csv file which already exist but in my scenarion every time instead of appending the contect it overwrite the file and creating new .csv file.

 
SET ORAUSR=ops$371664
SET ORAPWD=Oracle12345
SET ORADB=orcl
SET DBCON=%ORAUSR%/%ORAPWD%@%ORADB%
sqlplus -l -s %DBCON% @AEAE.sql >C:\opapps\xmltemp\AEAE.csv

,
What else option i have to mention in this script to append the file.

---------- Post updated at 08:06 AM ---------- Previous update was at 07:58 AM ----------

for append >>

2

Please modify the code

sqlplus -l -s %DBCON% @AEAE.sql >>C:opappsxmltempAEAE.csv