[askdba] Re: SQL data to Unix variables question
- From: "Subodh Deshpande" <subodh_deshpande@xxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx
- Date: Thu, 07 Oct 2004 06:02:14 -0500
hi regis,
if you want to do further processing on data then you have to use pro*c.
if you only want to spool then you have to write the spool file in sql part of
your script..
take care..subodh
----- Original Message -----
From: Regis Biassala <Regis.Biassala@xxxxxxxxxx>
Date: Thu, 7 Oct 2004 11:55:05 +0100
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] SQL data to Unix variables question
> Hi,
> Maybe one of you might already have this somewhere and certainly will help
> me save time to develop one of me own.
>
> My Question:
> Suppose a query like this:
>
> Select name, sal from emp;
>
> Result:
> Name Sal
> ----------- -----
> Mikey 110
> Justin 120
> Louis 100
>
> I'd like to store that info in Unix variables (int and string as you may see
> there).
> NOTE: we've got 3 rows, and this certainly will loop to process each row in
> unix.
>
> Does one know how to accomplish this?
>
> Thanks,
> Regis
> -----------------------
> Regis Biassala (DBA)
> Direct: +353 1 8063613
>
>
Good Luck..Subodh Deshpande
===============================================
Experience Is Knowledge
Wisdom Is Philosophy
==============================================
--
_______________________________________________
Find what you are looking for with the Lycos Yellow Pages
http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.asp?SRC=lycos10
Other related posts:
