varchar2(10 2) in oracle sql code example
Example: oracle sql number to varchar2
-- Number to Varchar2
DECLARE
myString VARCHAR2(10);
myNumber NUMBER := 100.56;
BEGIN
myString := to_char(myNumber);
DBMS_OUTPUT.PUT_LINE(myString); -- 100,56
END;