I am trying to develop a sql statement to produce the following:

ALTER TABLESPACE ALM_DSEG1_TSP ADD DATAFILE 'C:\SV\ALM\ADM\ALMDS1.TSP'
SIZE 50M REUSE AUTOEXTEND ON NEXT 5M MAXSIZE 4000M ;

I am using the following select statement to get the results.

select 'ALTER TABLESPACE '|| tablespace_name || ' ADD DATAFILE '
|| substr(file_name,3,24)
|| ' SIZE 50M REUSE AUTOEXTEND ON NEXT 5M MAXSIZE 4000M ;'
from dba_data_files
where tablespace_name = 'ALM_DSEG1_TSP';

However, I am not able to get the single tick or quote mark before the "C:" or after the "TSP". I manually type it in.

Any suggestions?