Execute the below SQL Query:
1 |
select regexp_replace('$ 8740,094. 30', '[[:space:]]*','') as FORMATED_OUTPUT from dual |
1 2 3 |
FORMATED_OUTPUT --------------- $8740,094.30 |
1 |
select regexp_replace('$ 8740,094. 30', '[[:space:]]*','') as FORMATED_OUTPUT from dual |
1 2 3 |
FORMATED_OUTPUT --------------- $8740,094.30 |
Hi there. just wondering,
Is that query same as
select replace(‘$ 8740,094. 30′,’ ‘,”) as FORMATED_OUTPUT from dual
Mine looks easier to maintain, unless I am missing something. Please let me know.