title: How to select partition name of specific data?
body: <p>I want to select a data and wanna see in which partition.</p>
  
  <blockquote>
    <p>partition column is : code (varchar column)</p>
  </blockquote>
  
  <pre><code>Select .... -- I want to find partition name
  from
  partition_table
  where to_number(code) = 55;
  </code></pre>
  
  <p>why I need to this:</p>
  
  <p>I have a data which code is '55' but in that table when I use partition column I do not select it. But there is data which value is '55'</p>
  
  <p>So I want to that data in which partition.</p>
  
  <p>And the data is not in <strong>PDEFAULT</strong> partition. I ve already check it.</p>
  
  <h2>edit</h2>
  
  <p>data is in another partition. I think there is a problem with exchange partition process </p>
  
  <p>thanks in advance</p>