web analytics

Start sqlplus in Windows .BAT script

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% […]