I am attempting to create a substitution variable for a number incrementer. We have this one in place already, but it only returns a single digit number. I need it to return a number with leading zeros.
For example:
Current query returns: 1
Need query to return: 001
Here is how the query is currently written:
select to_char(to_number(so_var_value)+1)
from so_sub_vars
where so_var_name = '#RDC_file_number'
Thanks in advance for any assistance!