title: Reversing numbers in Oracle SQL
body: <p>I'm trying to figure out how to make it so that the second <code>s_pin</code> returns its contents in reverse. So <code>"Coded Pin"</code> needs to be <code>s_pin</code> in reverse.</p>
  
  <pre><code>SELECT s_last||', '|| s_first||LPAD(ROUND(MONTHS_BETWEEN(SYSDATE, s_dob)/12,0),22,'*' ) AS "Student Name and Age", s_pin AS "Pin", Reverse(s_pin) AS "Coded Pin"
  FROM student
  ORDER BY s_last;
  </code></pre>
  
  <p>Output would look like this:<br/>
  <img src="https://i.stack.imgur.com/DHnXO.png" alt="enter image description here"></p>