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

0 vote204 views2 answers
Show slave status mysql
SQL
0 vote203 views1 answer
Psql no such file or directory
SQL
0 vote230 views1 answer
Datagrip execute procedure
SQL
0 vote214 views1 answer
Get create sql of hibernqte entity
SQL
0 vote215 views1 answer
Android sqlite get rows count
SQL
1 vote241 views1 answer
Customer using hdfc bank sql query
SQL
1 vote213 views1 answer
Add sequence postgres
SQL
3 votes222 views2 answers
Mysql create timestamp column
SQL
7 votes202 views1 answer
Query delete duplicates
SQL
0 vote215 views1 answer
Find and replace database table phpmyadmin
SQL