title: Right and Replicate in Oracle
body: <p>I have this line of query in SQL sever and would like to convert it in Oracle. Would someone please provide some pointer?</p>
  
  <pre><code>CAR_CD      CAR_YR      CAR_MONTH   CAR_SEQ
  LXR          2017          12          1234
  </code></pre>
  
  <p>I would like the outcome like this, using the query below in ORACLE database, not in SQWL.</p>
  
  <p>LXR1712001234</p>
  
  <pre><code>CAR_CD + SUBSTRING(CAST(CAR_YR AS VARCHAR(4)),3,2) + CAR_MONTH + RIGHT(REPLICATE('0',6) + CAST(CAR_SEQ AS VARCHAR(6)),6)   AS CAR_NUMBER,
  </code></pre>