> > Hi Mateusz, >> >> thanks for the help and the sample! I will try to implement it. I have >> also >> received a sample from an Oracle DBA how to create a Batch file with a >> properly defined command line while executing an SQL script with some >> PL/SQL >> procedures. >> > > Dejan, > > Sounds good. > > If interested, I will send it to you, when completed developing and testing >> it. >> > > IMO, mailing list (ie. as reply to this thread) is better place, so others > can use it as well. >
Here is the sample code to start with in PL/SQL and SQL in Oracle. The typical 'preamble' for doing this in Sql*plus is set heading off feedback off pagesize 0 newpage 0 Then you could do virtually anything column dag noprint new_value dag select to_char(sysdate,'yymmdd') dag from dual; spool exp_&dag..bat select .... from .... spool off host exp_&dag..bat exit Best regards, Dejan
_______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
