pl/sql loop help

[Rahul Tiwari]

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.

[Yogeeraj_1]

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

[Rahul Tiwari]

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]

closing the thread .