偷懶寫指令碼中特殊符號的轉譯

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;