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;

Similar codes

1 vote101 views1 answer
Set id count mysql
SQL
0 vote102 views1 answer
How to change null display in psql
SQL
0 vote113 views1 answer
How to install mysql without admin rights
SQL
1 vote110 views1 answer
Oracle drop temporary table
SQL
0 vote192 views1 answer
Run mysql xampp shell
SQL
5 votes165 views1 answer
Oracle source query
SQL
0 vote117 views1 answer
Two inner joins sql
SQL
0 vote133 views1 answer
How to check foreign key constraint in sql
SQL
6 votes105 views1 answer
Oracle trigger after connect
SQL
0 vote114 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL