SELECT TO_CHAR (prod_price* .25, ‘$99,999.99’) FROM PRICE_LIST
SELECT TO_CHAR (TO_NUMBER(prod_price) * .25, ‘$99,999.00’) FROM PRICE_LIST
SELECT TO_CHAR (TO_NUMBER(prod_price, ‘99,999.99’)∗.25,‘99,999.99’) * . 25, ‘99,999.99’)∗.25,‘99,999.00’) FROM PRICE_LIST
SELECT TO_NUMBER (TO_NUMBER(prod_price, ‘99,999.99’)∗.25,‘99,999.99’) * . 25, ‘99,999.99’)∗.25,‘99,999.00’) FROM PRICE_LIST