Showing posts with label Below SQL code reference is used to specify the thousands seperator automatically at database level.. Show all posts
Showing posts with label Below SQL code reference is used to specify the thousands seperator automatically at database level.. Show all posts

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