oracle sql number to varchar2 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;