Re: Forgotten method SQL+ and DOS

From: Nigel Thomas <nigel_cl_thomas@xxxxxxxxx>
To: oracle.rdbms@xxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
Date: Sun, 4 Feb 2007 07:05:32 -0800 (PST)

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

Follow-Ups:

Re: Forgotten method SQL+ and DOS
From: Sinardy Xing

Re: Forgotten method SQL+ and DOS

Other related posts: