update

[aryasen]

you still have to test and not give crap answers, worse than no answer at all

hello,

I tested properly Can you tell what is wrong in that?


SQL> select to_number( substr('12345-6',1,(instr('12345-6','-')-1)) ||substr('12345-6',(instr('12345
-6','-')+1),( length('12345-6')-instr('12345-6','-')) ) )
2 from dual;

TO_NUMBER(SUBSTR('12345-6',1,(INSTR('12345-6','-')-1))||SUBSTR('12345-6',(INSTR(
--------------------------------------------------------------------------------
123456

SQL> select to_number(substr('12345-6',1,(instr('12345-6','-')-1)))
2 from dual;

TO_NUMBER(SUBSTR('12345-6',1,(INSTR('12345-6','-')-1)))
-------------------------------------------------------
12345