How to spool single quotes in text file ?

Hi!

I'm trying to generate a text file, that spools all datafiles in a database and generates an alter database file.

set heading off
set feedback off
set linesize 300;
set pagesize 200;
spool c:\datafiles.sql;
select 'alter database datafile ' ||name|| ' autoextend on next 50m maxsize 1000m;' from v$datafile;
spool off
@c:\datafiles.sql
exit

How do I get Oracle to do single quotes around the datafile names? Simply using two single quotes doesn't work...

select 'alter database datafile '' ||name|| '' autoextend on next 50m maxsize 1000m;' from v$datafile;

Gives me
alter database datafile ' ||name|| ' autoextend on next 50m maxsize 1000m;

Any idea?

This is 8.1.6. Received on Fri Nov 03 2000 - 12:41:27 CST