Hi,

Requirement:-

SQLs

select name from v$datafile;
select name from v$controlfile;
select name from v$tempfile;
select MEMBER from v$logfile;

These sqls has to run in one script and o/p of each sql has to write in seperate files.But the o/p is like if we issue
select name from v$datafile; o/p is like this

/path/datafilename1
/path/datafilename2
-------------------

but here need to get the o/p as like this

rm -rf /path/datafilename1
rm -rf /path/datafilename2

like that all sql o/p has to come like this and write in seperate files,so that can execute that files only

please help to create a script for the same