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

3 votes179 views1 answer
Mysql load sql from file
SQL
0 vote178 views1 answer
Change role postgres
SQL
1 vote227 views1 answer
Sql server locks
SQL
0 vote167 views1 answer
Oracle list of long running queries
SQL
0 vote391 views1 answer
Redirection 301 htaccess nom de domaine
SQL
0 vote178 views1 answer
Procedure excute monthly oracle
SQL
2 votes205 views3 answers
Postgres json to string
SQL
0 vote179 views1 answer
Sql server query database space available
SQL
0 vote139 views0 answer
SQL
0 vote190 views1 answer
Phpmyadmin mysql conflict
SQL