SQL How to convert decimal string to string

Question

In the SELECT statement, I want to convert the values ​​to strings, i.e. SELECT TO_STRING (value).

How to do it in Oracle SQL?

Answer 1

You can use TO_CHAR or CAST :

 SELECT TO_CHAR(123.45) FROM DUAL SELECT CAST(123.45 AS VARCHAR2(10)) FROM DUAL 

Answer 2

 SELECT CAST(column_name as data_type) from ... 

can work

NTN