title: Oracle SQL, Search for string in one column that contains string from another column
body: <p>Currently have this table, and need to be able to find Sentences that contain the name of a person</p>
  
  <pre><code>ID         FIRSTNAME       LASTNAME        EMAIL                         PHRASE
  --------  --------------- ------------     ---------------------------   ---------------------------------------------------------------          
  1          John            Smith           jsmith@faker.com              I'm the same as other people.
  2          Sarah           Lane            saralane23@faker.com          I'm different from other people
  3          Allen           Borazt          allenB@faker.com              I guess I need another job.
  4          Mike            Himmy           mh@faker.com                  We have a great time. John Smith really enjoys his time out.
  5          Jillian         Carters         jcartrs@faker.com             What happened to the car? 
  6          Steven          Oarts           SteveO2@faker.com             Just chillin' over in the pool
  7          Ronald          Donalds         don@faker.com                 Just in case you were wondering
  8          Nancy           Arist           nArist@faker.com              What I really want is Paul Blarts movie.
  9          Paul            Blart           paulb@faker.com               I think Nancy Arist hair color is cool.
  </code></pre>
  
  <p>Right now my query looks like this but it returns "No Rows Selected".</p>
  
  <pre><code>SELECT T.*
  FROM Table T
  WHERE T.Phrase Like '%' || T.FirstName || '%';
  </code></pre>
  
  <p>My desired result would look like this.</p>
  
  <pre><code>ID         FIRSTNAME       LASTNAME        EMAIL                         PHRASE
  --------  --------------- ------------     ---------------------------   ------------------------------------------------------------------------------------------------------------------------               
  4          Mike            Himmy           mh@faker.com                  We have a great time. John Smith really enjoys his time out.
  8          Nancy           Arist           nArist@faker.com              What I really want is Paul Blarts movie.
  9          Paul            Blart           paulb@faker.com               I think Nancy Arist hair color is cool.
  </code></pre>