SQL Language (MOSC)

MOSC Banner

fuzzy query in windows batch shell

edited Apr 17, 2013 9:01PM in SQL Language (MOSC) 2 commentsAnswered
ENV:win2008 ,oracle11g

In sqlplus: select 'del ' || file_name||';' from dba_data_files where   tablespace_name like 'SHFRM%'  ;

In batch shell(not work):

set var=%1
@echo off
(
echo / as sysdba
echo set cmdsep on
echo set cmdsep '"'; --"
echo "set head off"
echo "set feedback off"
echo "spool file.sql"
echo "select 'del ' || file_name||';' from dba_data_files where tablespace_name like '%var%%';"
::echo "prompt EXIT;"
echo "spool off"
) | sqlplus -s

I ran the batch:< batch.bat SHFRM >in windows cmd, no result spooled in file.sql,there might be mistake in batch,please help...

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center