unix script

I'm writing a Unix script that needs to use some values frorm Oracle as variables:

ex: select Apples, Oranges, Pears

      from table;

I need to make Apples, Oranges, etc each it's own variable in the script. Can I do this without writing 3 different select statements?

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Aug 20 1998 - 12:45:16 CDT