TO_NUMBER
Converts char value expressing a number to a NUMBER datatype.
UPDATE customers SET rating=rating + TO_NUMBER(SUBSTR('$10',2,2));
TO_CHAR(date,[format])
- converts a value of a DATE datatype to CHAR value.
- default date format is "DD-MON-YY"
SELECT TO_CHAR(odate,'Month DD,YYYY') "New Date Format" FROM Orders;