Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Equivalent of UNIX hear document on Windows NT

Equivalent of UNIX hear document on Windows NT

From: <dbaplusplus_at_hotmail.com>
Date: 7 Mar 2006 19:56:02 -0800
Message-ID: <1141790162.392386.165080@u72g2000cwu.googlegroups.com> 






Versions  of Oracle and UNIX are  not relevant. But I work on HP UNIX
using Oracle9i.



When writing shell scripts, I use Unix's here document, e.g.,



Sqlplus /nolog << !


Conn scott/tiger


Statement1


Statement2


!




How can I do the same on Windows NT/2000. I am writing .bat files,
I end up separating .sql from .bat file, e.g.
cmd.sql will contain


conn Scott/tiger


Statement 1


statement2




Then cmd.bat will contain:


Sqlplus /nolog @cmd.sql



Is there a way to merge cmd.sql with cmd.bat so there is one file on
Windows 2000
Received on Tue Mar 07 2006 - 21:56:02 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US