Script to create files

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

#!/bin/bash
echo "select 'rm -rf '||name from v\$datafile;" | sqlplus "/ as sysdba" | grep "^rm -rf" > file1
echo "select 'rm -rf '||name from v\$controlfile;" | sqlplus "/ as sysdba" | grep "^rm -rf" > file2
echo "select 'rm -rf '||name from v\$tempfile;" | sqlplus "/ as sysdba" | grep "^rm -rf" > file3
echo "select 'rm -rf '||MEMBER from v\$logfile;" | sqlplus "/ as sysdba" | grep "^rm -rf" > file4
1 Like

thanksss