cancel
Showing results for 
Search instead for 
Did you mean: 

pl/sql loop help

Rahul Tiwari
Advisor

pl/sql loop help

Hello ,

i want to loop a sql query , say like SHOW PARAMETER
where comes from a file, and the resultant output
goes into another file .Any other suggestion to accomlish this.
3 REPLIES
Yogeeraj_1
Honored Contributor

Re: pl/sql loop help

hi,

it would be better to just query the v$parameter and spool the output to a file.


you may also include the clause to limit the output to the parameters that you have identified.

e.g.
spool paramters.lis
select * from v$parameter
where name in ('pga_aggregate_target','open_cursors','...');


hope this helps!

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Rahul Tiwari
Advisor

Re: pl/sql loop help

Thank you Yogiraj ,
I was just looking for something equvalent in pl/sql like -
for i in`cat /home/test1/spool1`;do;something $i >> //home/test1/spool2;done;
Rahul Tiwari
Advisor

Re: pl/sql loop help

closing the thread .