Friday, August 26, 2011


Below PeopleCode reference is used to send the HTML mail format.

&ContentType = "Content-type: text/html; charset=UTF-8";
SendMail(0, &strEmailTo, &strEmailCC, &strEmailBCC, &Subject, &Message, &strFileNames, &strFileTitles, &tempEmailReplyTo, ";", &ContentType);

Below SQL code reference is used to specify the thousands seperator automatically at database level.
SELECT TO_CHAR(2354867423595,'99G99G99G99G99G99G999') FROM PSCLOCK

No comments: