CODE EXAMPLE FOR SQL

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;