<div dir="ltr"><div class="gmail_quote">
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div class="Ih2E3d">
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hi Mateusz,<br><br>thanks for the help and the sample! I will try to implement it. I have also<br>received a sample from an Oracle DBA how to create a Batch file with a<br>
properly defined command line while executing an SQL script with some PL/SQL<br>procedures.<br></blockquote><br></div>Dejan,<br><br>Sounds good.
<div class="Ih2E3d"><br><br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">If interested, I will send it to you, when completed developing and testing<br>it.<br></blockquote><br></div>
IMO, mailing list (ie. as reply to this thread) is better place, so others can use it as well.
<div>
<div></div></div></blockquote>
<div> </div></div>
<div class="gmail_quote"><font face="courier new,monospace">Here is the sample code to start with in PL/SQL and SQL in Oracle.</font></div>
<div class="gmail_quote"><font face="courier new,monospace"></font> </div>
<div class="gmail_quote"><font face="courier new,monospace">The typical 'preamble' for doing this in Sql*plus is<br><br><font face="courier new,monospace" color="#660000">set heading off feedback off pagesize 0 newpage 0</font><br>
<br><font face="arial,helvetica,sans-serif">Then you could do virtually anything</font><br></font></div>
<div class="gmail_quote"><font color="#660000"><font face="courier new,monospace">column dag noprint new_value dag<br>select to_char(sysdate,'yymmdd') dag<br>from dual;<br><br>spool exp_&dag..bat<br><br>select ....<br>
from ....<br>spool off<br><br>host exp_&dag..bat<br>exit</font><br></font></div>
<div class="gmail_quote"><font color="#000000">Best regards,</font></div>
<div class="gmail_quote"><font color="#660000"><font color="#000000">Dejan</font></font></div></div>