Forgotten method SQL+ and DOS

  • From: "Sinardy Xing" <oracle.rdbms@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Sat, 3 Feb 2007 15:14:41 +0800

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: