Your question, your audience. Choose who sees your identity—and your question—with question security.
LPAD with a <space> instead of the '0' from your previous question? lpad(column,' ',9)
select lpad(to_char(123.45*100,'fm999999990'),9,' ') from dual;
Open in new window
SQL> select substr(1234567890,-9) from dual;
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.