Using the TO_CHAR function in a SQL statement

Here is my query:

select item_id, sum(price*qoh) "Inv. Value" FROM inventory
group by item_id;

How would I write this query using the TO_CHAR function to format the number values using a currency format masked with two decimal places?

Thanks
John Received on Sun May 26 2002 - 15:39:20 CDT