SQL & PL/SQL

Hello Folks,

I want to know what the TO_NUMBER function does when we add the format string 'X' as its second parameter.

For example, consider the below query,

select to_number('12345','XXXXX') from dual;

Result:

74565

Thanks!