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

--

http://www.freelists.org/webpage/oracle-l Received on Sat Feb 03 2007 - 01:14:41 CST