Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: is is possible to retrieve a SELECT query's result in a shell script?

Re: is is possible to retrieve a SELECT query's result in a shell script?

From: Grégory Luguet <gregory.luguet_at_evidian.com>
Date: Wed, 22 May 2002 10:54:05 +0200
Message-ID: <acfm1s$8ca1@tosca.bull.fr>


Thank you I will consider this option

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:ohobeuo5dk4487lbmr423lr44v6vkghbsm_at_4ax.com...
> On Thu, 16 May 2002 18:32:02 +0200, "Grégory Luguet"
> <gregory.luguet_at_evidian.com> wrote:
>
> >I am answering myself : I use the SPOOL directive to write the result in
a
> >file that I later parse
> >
> >> Hello all,
> >>
> >> I have to subordinate a procedure to the content of a field in a table.
> >> I can launch sql procedures in .sql files from my script, but now I
need
> >to
> >> retrieve a result : is it possible? and if so, how?
> >> I use Oracle 8i (8.1.6 & 8.1.7) DB and my script runs on Unix (AIX or
> >SunOS)
> >>
> >> thanks in advance
> >>
> >>
> >
>
> No need to spool. Piping the output definitely will work provided you
> use sqlplus -s and set feedback off inside your script.
>
> Hth
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Wed May 22 2002 - 03:54:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US