Sinardy
In Windows you can pipe out from a sequence of commands - eg:
(
echo select sysdate from dual
echo /
echo exit
) | sqlplus / as sysdba
Ithis works in Unix too, of course)
In an interactive session it looks like:
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\Nigel Thomas>(
More? echo select sysdate from dual
More? echo /
More? echo exit
More? ) | sqlplus testuser/testuser
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Feb 4 15:00:49 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL> 2
SYSDATE
---------
04-FEB-07
SQL> Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 -
Production
C:\Documents and Settings\Nigel Thomas>
HTH
Regards Nigel
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Feb 04 2007 - 09:05:32 CST
