Use LENGTH to measure the total size of your strings:
SELECT LENGTH('INV#8674767JSDEPOSIT PO12345678') AS str_length
FROM dual;This helps validate whether parsing logic is correct and if input values have consistent lengths.
Use LENGTH to measure the total size of your strings:
SELECT LENGTH('INV#8674767JSDEPOSIT PO12345678') AS str_length
FROM dual;This helps validate whether parsing logic is correct and if input values have consistent lengths.