I have spooled a file to CSV using sqlplus. Everything works great but there is one issue. I have mobile numbers which start with 0, for example 04589 and 02586.
After the spooling is complete, 0s are truncated and the end results are 4589 and 2586.
I want the output to display in CSV as:
04589
02586