Re: Trying to write a short script

From: Subodh Deshpande <deshpande.subodh_at_gmail.com>
Date: Fri, 23 Sep 2011 10:08:16 +0530
Message-ID: <CAJsOtB7jUcxkdmzNYU6cOqYE=xSV4BRjpWgKb3s7CGTBJM61Yg_at_mail.gmail.com>

oh great you solved...it... :) ..subodh
On 23 September 2011 02:22, Laurent, Vincent <Vince_Laurent_at_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 / _at_dbverion
>
> *sigh*
> I figured I post my answer for feedback.
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Laurent, Vincent
> Sent: Thursday, September 22, 2011 3:43 PM
> To: oracle-l_at_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

Received on Thu Sep 22 2011 - 23:38:16 CDT