偷懒写脚本中特殊符号的转译

select 'alter database datafile '||''''||name||''''||'resize 100m;' from v$datafile;
输出结果为
alter database datafile '/u01/app/oracle/oradata/PROD1/system01.dbf'resize 100m;
alter database datafile '/u01/app/oracle/oradata/PROD1/sysaux01.dbf'resize 100m;
alter database datafile '/u01/app/oracle/oradata/PROD1/undotbs01.dbf'resize 100m;
alter database datafile '/u01/app/oracle/oradata/PROD1/users01.dbf'resize 100m;
alter database datafile '/u01/app/oracle/oradata/PROD1/example01.dbf'resize 100m;