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 like
/path/datafilename1
/path/datafilename2
-------------------
So need to change the o/p as
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