Removing Leading Zeros:
Sample data:
SQL> SELECT '0000100' AS Num FROM dual;
NUM-------0000100
Option 1:
SQL> SELECT To_Number('0000100') AS Num FROM dual;
NUM---------- 100
Option 2:
SQL> SELECT LTrim('0000100','0') AS Num FROM dual;
NUM---1...
