I am generating number range from Oracle XMLTABLE which is working fine. Now what I want that When I am entering number with multiple zero before actual number then I am getting below result.
SELECT TO_NUMBER(column_value) range_value FROM XMLTABLE(000093 || ' to ' || 000095);
result
93
94
95
I need result like below.
000093
000094
000095