unwanted leading blank space on oracle number format
oracle, sql
Solution
Use FM (Fill Mode), e.g.
`select to_char(1011,'FM00000000') OPE_NO from dual;`
Problem
I need to pad numbers with leading zeros (total 8 digits) for display. I'm using oracle. ``` select to_char(1011,'00000000') OPE_NO from dual; select length(to_char(1011,'00000000')) OPE_NO from dual; ``` Instead of '00001011' I get ' 00001011'. Why do I get an extra leading blank space? What is the correct number formatting string to accomplish this? P.S. I realise I can just use `trim()`, but I want to understand number formatting better. @Eddie: I already read the documentation. And yet I still don't understand how to get rid of the leading whitespace. @David: So does that mean there's no way but to use `trim()`?