Select * from table(apex_string.split('123|1234|12345','|'))| COLUMN_VALUE | 123 | 1234 | 12345 |
|---|
Select to_char(column_value,'fm999,999') from table(apex_string.split('123|1234|12345','|'))| TO_CHAR(COLUMN_VALUE,'FM999,999') | 123 | 1,234 | 12,345 |
|---|
with t as (Select to_char(column_value,'fm999,999') val
from table(apex_string.split('123|1234|12345','|')
))
select * from t| VAL | 123 | 1,234 | 12,345 |
|---|
with t as (Select to_char(column_value,'fm999,999') val
from table(apex_string.split('123|1234|12345','|')
))
select listagg(val,'|')
from t| LISTAGG(VAL,'|') | 123|1,234|12,345 |
|---|