Re: Forgotten method SQL+ and DOS

  • From: "Sinardy Xing" <oracle.rdbms@xxxxxxxxx>
  • To: "Nigel Thomas" <nigel_cl_thomas@xxxxxxxxx>
  • Date: Mon, 5 Feb 2007 09:59:26 +0800

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

Other related posts: