To repeat a query

[Vincenzo Restuccia]

I want to repeat this query 295 times and I have the name "variable" in a file or in a db table. I want a PL/SQL script.


select * from nas where name='variable'


Thanks

[Sridhar Bhaskarla]

Hi,

A DBA may answer your question better.

Meanwhile, this is what I did for my cgi's.

sql_file contents


...
select * from table where name="REPLACE_THIS"
..

Following is the CGI

...
VAR=$1 #an example of assigning a variable
sed 's/REPLACE_THIS/,/'$VAR'/' sql_file > /tmp/sql$$

/tmp/sql$$ #run the sql script

rm /tmp/sql$$

...

-Sri

[harry d brown jr]

Have you thought about using perl?

http://tlowery.hypermart.net/perl_dbi_dbd_faq.html

http://www.saturn5.com/~jwb/dbi-examples.html

and a library of perl docs :

http://www.palslib.com/Perl_DBI/Readings.html


live free or die
harry