title: right justified and left zero filled in oracle?
body: <pre><code>SELECT RIGHT('000000' + CAST([ID] as SYSNAME), 8) ID 
    FROM Table1
  </code></pre>
  
  <p>The above query makes a column right justified and left zero filled in sql server.
  Can Some one let me know the equivalent in Oracle DB?</p>