[askdba] SQL data to Unix variables question

  • From: Regis Biassala <Regis.Biassala@xxxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Thu, 7 Oct 2004 11:55:05 +0100

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


Other related posts: