title: How to format integers slighty left in sql*plus?
body: <p>I have a question on how to format the values of a column to be slightly left justified=right.. Here is what i have:</p>
  
  <p><a href="https://i.stack.imgur.com/OsBml.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OsBml.png" alt="enter image description here"></a></p>
  
  <p>The format Im looking for is justified right and the number should be in format of 'nn##' where # is representing 'space'. figure 2 shows what I'm looking for:</p>
  
  <p><a href="https://i.stack.imgur.com/Jitot.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Jitot.png" alt="enter image description here"></a></p>
  
  <p><strong>UPADE_1</strong>
  The command <code>SELECT dname, deptno||'', loc FROM dept;</code> excecutes as:
  <a href="https://i.stack.imgur.com/jbV6A.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jbV6A.png" alt="enter image description here"></a></p>