Hi all,
Please help me out... i want to convert the to_char into number format....
please let em know how to do it...
for eg:
i have a statement : to_char(p_number, 'S000000')
this converts the number into proper format....
now i want to convert tht 'S000000' char back to the original number p_number.....
Can anyone tell me how to do it please :confused:
Thanks a lot
:)