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% is replaced by empty string.
Spaces are mandadory in "/* some_label */" string.

Topics: Oracle, Windows scripts, bat, sqlplus | Submitter: checkthis

Comments

You must be logged in to post a comment.