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

38 votes200 views6 answers
Alter table mysql
SQL
0 vote147 views1 answer
Recover deleted data from mysql database
SQL
0 vote142 views1 answer
Sql case when exists in another table
SQL
0 vote150 views1 answer
Mssql disable foreign key constraint
SQL
0 vote156 views1 answer
Oracle show grants on table
SQL
0 vote205 views1 answer
Do you know sql
SQL
0 vote128 views2 answers
Get top 1 row of each group
SQL
0 vote156 views1 answer
Drop unique
SQL
0 vote156 views1 answer
USING THE NOT CONDITION IN SQL
SQL
0 vote143 views1 answer
Mysql select smaller of two values
SQL