MIME-Version: 1.0
In-Reply-To: <EF763CC31BB89B47B435AE02FE42263F0472417D21@S009-APEXM05.ds.ad.ssmhc.com>
References: <EF763CC31BB89B47B435AE02FE42263F0472417D1C@S009-APEXM05.ds.ad.ssmhc.com>
 <EF763CC31BB89B47B435AE02FE42263F0472417D21@S009-APEXM05.ds.ad.ssmhc.com>
Date: Fri, 23 Sep 2011 10:08:16 +0530
Message-ID: <CAJsOtB7jUcxkdmzNYU6cOqYE=xSV4BRjpWgKb3s7CGTBJM61Yg@mail.gmail.com>
Subject: Re: Trying to write a short script
From: Subodh Deshpande <deshpande.subodh@gmail.com>
To: Vince_Laurent@ssmhc.com
Cc: "oracle-l@freelists.org" <oracle-l@freelists.org>
Content-type: text/plain
Content-Transfer-Encoding: 8bit
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: deshpande.subodh@gmail.com

oh great you solved...it... :) ..subodh
On 23 September 2011 02:22, Laurent, Vincent <Vince_Laurent@ssmhc.com>wrote:

> I hate it when I solve it the moment after I post.
> I just created an sql file called dbversion.sql with the following:
>
> select banner
> from   sys.v_$version;
> exit
>
> then from inside my unix script I just call it:
>
> sqlplus -s / @dbverion
>
> *sigh*
> I figured I post my answer for feedback.
>
> -----Original Message-----
> From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]
> On Behalf Of Laurent, Vincent
> Sent: Thursday, September 22, 2011 3:43 PM
> To: oracle-l@freelists.org
> Subject: Trying to write a short script
>
> I am currently using Oracle 11.2.0.2 on HP-UX 11.31
> I have a script that does this:
>
>  # Get the path to the trace files
>  DUMP=`/oracle/$ORACLE_SID/112_64/bin/sqlplus -s / as sysdba <<EOF
>  set head off
>  set feedback off
>  select * from v\\$version;
>  exit
>  EOF`
>  echo $DUMP
>
> but the output comes back like this (all wrapped as one line):
>
> Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit
> Production PL/SQL Release 11.2.0.2.0 - Production CORE 11.2.0.2.0 Production
> TNS for HPUX: Version 11.2.0.2.0 - Production NLSRTL Version 11.2.0.2.0 -
> Production
>
> Instead of like this (each product it's own line):
>
> Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit
> Production
> PL/SQL Release 11.2.0.2.0 - Production
> CORE    11.2.0.2.0      Production
> TNS for HPUX: Version 11.2.0.2.0 - Production
> NLSRTL Version 11.2.0.2.0 - Production
>
> Ideas to fix?
>
>
>
> Confidentiality Notice: This email message, including any
> attachments, is for the sole use of the intended recipient(s) and
> may contain confidential and privileged information. Any
> unauthorized review, use, disclosure or distribution is prohibited.
> If you are not the intended recipient, please contact the sender by
> reply email and destroy all copies of the original message.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


-- 
==============================
DO NOT FORGET TO SMILE TODAY
==============================


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