====== Batch Files ======

===== No spaces around assignment statements. =====
 <code>set x=2 ok.</code> <code>set x = 2 will not work.</code>

===== Ping all ip addresses on home net =====
 <code>REM use %% in a batch file
for /l %x in (1, 1, 255) do ping /n 2 192.168.12.%x >> ping.txt</code>

===== This batch file looks for x86 or x64 =====
<code>
@echo off
IF "%1"=="" GOTO bad
IF "%1"=="x86" GOTO ok
IF "%1"=="x64" GOTO ok
:bad 
echo "parameter must be x86 or x64"
goto end
:ok
echo using %1%
:end
</code>

===== This batch file get the date and time in yyyy-mm-dd-hh-mm format =====
<code>
echo off
echo %date%
set year=%date:~10,4%
set month=%date:~4,2%
IF "%MONTH:~0,1%" == " " SET MONTH=0%MONTH:~1,1%
set day=%date:~7,2%
IF "%DAY:~0,1%" == " " SET DAY=0%DAY:~1,1%
echo %time%
set hour=%time:~0,2%
IF "%HOUR:~0,1%" == " " SET HOUR=0%HOUR:~1,1%
set minute=%time:~3,2%
IF "%Minute:~0,1%" == " " SET Minute=0%Minute:~1,1%
set ts=%year%-%month%-%day%_%hour%-%minute%
echo %ts%
</code>

Sample usage<code>
sqlplus jwars/password@jas @createJwarsTableCreationSql.sql > createJwarsTableCreationSql%ts%.log
</code>