I know to_char is able to format the 'date' datatype for the result. Will it also be able to format 'number' and 'currency' datatypes? To be more specific, I want the 'number' to be shown as
?9999.99?, and the 'currency' as ?$9,999.99?? I found there is a 'Format' function, but don't know how to use it. Please help.