|
next
|
Subject: LEADING BLANKS IN XML LINE Author: NOMA STUART Date: 18 Feb 2005 10:37 AM
|
SELECT NVL(TO_CHAR(clm.workresumedate,'YYYYMMDD'),' ')
,LPAD(TO_CHAR(clm.claimedcredits),4,' ') ||
LPAD(clm.availablecredits,4,' ') ||
LPAD(clm.averagesalary,13,' ') ||
LPAD(paym.salaryfrequencyid,4,' ')
PutXML('<extended_desc2>' || pmtrec(ndx).ext || pmtrec(ndx).ext2|| '</extended_desc2>');
From the above select statement, I need to move the result into the XML line. Problem is date is sometimes spaces , I want to mantain those leading spaces.
thanks
Noma
|
|
|