title: Compare two delimited strings and return corresponding value in PL SQL
body: <p>I have two columns with a hashtag delimited value, i.e. <code>Email#Web#Telephone#SMS#MMS</code> &amp; <code>0#0#0#1#0</code> Note that each delimited value of the second column matches up with its corresponding delimited value in the first column, i.e. <code>Email = 0</code>, <code>Web = 0</code>, <code>Telephone = 0</code>, <code>SMS = 1</code> etc.
  Based on a parameter, I want to return the matching value of the second column. i.e. incoming param = <code>Web#Telephone#SMS</code>, thus the value that I want to return is <code>0#0#1</code>.</p>
  
  <p>This need to be done in PL SQL, and I have no clue where to start, which explains the lack of sample code.</p>
  
  <p>Any help please?</p>