Oracle, Pl/SQL: substitution/replace function

Question

I am facing a unique challenge, the problem I'm facing is something like this:

I need to ignore the zero from the input: For example

Example 1
Input --> 1580
output --> 158

Example 2
Input --> 3008
output --> 38

Is there any built function or through normal query I can solve the above problem or do I need to write custom pl/sql code.

Please suggest.

Andrew Paes · Accepted Answer · 2016-03-30 20:32:15Z

1

SQL:

select 3008 original, REPLACE(TO_CHAR(3008), '0', '') replaced from dual;

Result:

original | replaced
---------|----------
3008     | 38
---------|----------

answered Mar 30, 2016 at 20:32

Andrew Paes

2,0221 gold badge16 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1