How to convert the column sum-function-total to dollars in Oracle SQL?
This was a simple-syntax issue, which I unable to see due to my growing frustration-thank you.

SELECT TO_CHAR(sum(invoice_total),'$999,999.99') AS "Total Invoice Amount"
FROM company.invoices;