title: Concat multiple rows based on If/Then to poulate a 5 digit code
body: <p>Hoping someone can help.</p>
  <p>I have data as follows in two seperate columns in a table called StudentRace</p>
  <pre><code>Student_ID    RaceCD
  ----------    ------
  123456        1 
  123456        2
  589645        4
  987654        3
  987654        4
  </code></pre>
  <p>I am looking for a way to combine the data for the students by student id to output into 00000 format. example: Student_ID 123456 RACE: 12000; Student_ID 589645 Race: 00040; Student_ID 987654  Race = 00340. I need to have it be a sub query as it is part of a large report that pulls 50+ fields. If anyone is able to help I would greatly appreciate it. I am using Toads Data Point for Oracle to create my query.</p>