If You need the analog of Unix ‘which’ command and do not have Resource Kit, the following batch file will help.
The code was found on www.ss64.com
Published with the permission of the author, Clay Calvert.
@echo off
SETLOCAL
(set WF=)
:: Look for file in the current directory
for %%a in ("" %%) do (
if not defined WF if exist "%~1%%~a" set [...]
Here is the example of emulating “HERE-documents” in Windows shell.
@ECHO OFF
FIND "/*%none% some_label" <%0 |sqlplus USER/PASS@SERVER
GOTO end
: ———– embedded SQL————————-
/* some_label */ select count(*) from dba_free_space;
/* some_label */ select tablespace_name from dba_tablespaces;
: ———– end of embedded SQL————————-
:end
It’s also possible to use procedures in .bat files.
%none% is replaced by empty [...]
