desc melanson.relreq;
alter session set nls_date_format = 'yyyy-mm-dd hh24:mi:ss';

--set echo on;
set pagesize 0;
set heading off ;
set feedback off;
set linesize 600;

spool rr_deli.lis;
select rtrim(requestor,' ')
||'|'||rtrim(package,' ')
||'|'||rtrim(tag,' ')
||'|'||rtrim(NOTES,' ')
||'|'||rtrim(SPECIAL,' ')
||'|'||rtrim(REQUESTDATE,' ')
||'|'||rtrim(APPROVALDATE,' ')
||'|'||rtrim(RELEASEDATE,' ')
||'|'||rtrim(REMOVEDATE ,' ')
||'|'||rtrim(REQUESTBUILD ,' ')
||'|'||rtrim(APPROVALBUILD,' ')
||'|'||rtrim(RELEASEBUILD  ,' ')
 from melanson.relreq;
spool off;
