Looping using both oracle and shell

[bhagyamurali]

Hello everyone,

I have the following problem:

I want to select values from column a in table b and pass the value as a variable so that I can grep a file from the unix directory (based on the value a). If the file is found, then I want to move the file to another directory if not, then go onto value 2 in column a and repeat the process until all the rows are exhausted.

I would have to invoke sqlplus
select a from table b
where c=d (etc etc)

And from here I want to assign selected value a as a variable and use it to find a file.

How do I proceed? Please help...

thank you
b

 

[dickiebird]

See faq822-2218 (specifically) :

Background / Overview
SQL*Plus will happily integrate into the standard UNIX IO streams.
The simplest way to demonstrate this point is that the following UNIX command:
(Modified) :

yourvar="select a from table b where c=d (etc etc);" |sqlplus -s scott/tiger

HTH



Dickie Bird (-)))