Link to home
Create AccountLog in
Avatar of Alaska Cowboy
Alaska CowboyFlag for United States of America

asked on

how to format a number from Oracle being delivered via e-mail

I send this via e-mail, pulling data from Oracle via Pl-Sql and then a Send-mail routine.

CLM - NASCO MD - 035: Errors = 7, Loaded = 259364, percent errors = 0
MEM - FLEXX/Facets Merge - 104: Errors = 4648, Loaded = 137287, percent errors = 3

I know it's ugly, but at the moment all I want to do is add commas to the numbers, 259,364

I've done a little HTML tagging in e-mails, but not sure how to format the numbers
Avatar of Sean Stuber
Sean Stuber

convert the number to a string


to_char(loaded,'999,999')
Avatar of Alaska Cowboy

ASKER

ah, should have thought about that . . . will give it a shot, thanks.
SOLUTION
Avatar of johnsone
johnsone
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ok, didn't know about that, so thanks, will try in about an hour
and do both formats handle a million ?
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ok, thanks a lot, working on it now . . .
ok, fixed, thanks !