title: Contains() in XPATH both Tag name and value of attribute
body: <p>I have the an XML Column and it is similiar to the one mentioned below. </p>
  
  <pre><code>&lt;appl&gt;
  &lt;sftp_job name = "test1_ftp"&gt;
  &lt;ftp_job name = "test2_ftp"&gt;
  &lt;link name="testlink1"&gt;
  &lt;tag name ="task1_ftp"&gt;
  &lt;unix_job name="test123_ftp"&gt;
  &lt;/appl&gt;
  </code></pre>
  
  <p>My requirement is to get the value of all the atrributes that ends with "_ftp" like mentioned below.</p>
  
  <pre><code>test1_ftp
  test2_ftp
  task1_ftp
  test123_ftp
  </code></pre>
  
  <p>I have the below SQL statement and it is working fine.</p>
  
  <pre><code>SELECT JOB_NAME
    FROM
      (SELECT q.jobname AS JOB_NAME
       FROM DFTAB1
       LEFT JOIN xmltable('/appl/*[contains(name(),"_job") or 
                                   contains(name(),"link") or 
                                   contains(name(),"task") ]' 
     PASSING XMLTYPE(DEF) columns jobname VARCHAR2(20) path '@name')q ON (1=1)
       )
   WHERE JOB_NAME LIKE '%_ftp%'
  </code></pre>
  
  <p>and this is working. </p>
  
  <p>Is there a way that I can do in a single SELECT statement.</p>