Re: Forgotten method SQL+ and DOS

Hi Thomas,

Thanks it is working now

Regards,
Sinardy

On 2/4/07, Nigel Thomas <nigel_cl_thomas_at_yahoo.com> 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

--
http://www.freelists.org/webpage/oracle-l