Hi Thomas, Thanks it is working now Regards, Sinardy On 2/4/07, Nigel Thomas <nigel_cl_thomas@xxxxxxxxx> wrote:
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
-- regards, Sinardy