title: how do I split a numeric column into two separate columns in Oracle SQL
body: <p>I am trying to join two tables together but the key in one table is formated like 'xxxxxx' and the key I am trying to join together in the second table is formated like '2222xxxxxx'. Is there a way I can either split the second column into two different columns to make the join, or join on only the last 6 numbers of column 2?</p>
  
  <p>Notes: values are numeric. the '2222' is always the same 4 numbers.</p>