Forgotten method SQL+ and DOS

Hi guys,

How can i do following in windows

sqlplus / as sysdba << a
select sysdate from dual;
select sysdate from dual;
a

I know how to do it in just one command

echo select sysdate from dual; | sqlplus /as sysdba


The challange is I don't want to create any dummy file, just one plain bat
file
echo bla > dumb.dumb
echo blas >> dumb.dumb
type dumb.dumb | sqlplus / as sysdba
del dumb.dumb

I try to just have one bat file.



Thank

--
regards,

Sinardy

Other related posts: