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: Thu, 16 May 2002 18:32:02 +0200
Message-ID: <ac0miv$8k83@tosca.bull.fr> 





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

>

>

Received on Thu May 16 2002 - 11:32:02 CDT












Original text of this message













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