How to generate a OS xcopy command in one line not in two line in a spooled file

 Hello,

I write a sql script to generate a OS xcopy command in a spooled file but the output formate is not correct. The following is what I write:

set feedback off
set heading off

spool fullxcopy_backupfiles.cmd
 
select 'xcopy '||   name || '   e:\oracle\backup\fullbackup\flexprod /Y'
from
 v$datafile where status='ONLINE';
 
 select 'xcopy ' || member || '   e:\oracle\backup\fullbackup\flexprod /Y'
 from v$logfile where type='ONLINE';

 
 select 'xcopy ' ||name || '  e:\oracle\backup\fullbackup\flexprod /Y'
from v$tempfile where status='ONLINE';

 SELECT 'xcopy ' ||NAME || '   e:\oracle\backup\fullbackup\flexprod /Y'