title: How to drop list of table from a schema in Oracle?
body: <p>My Oracle scott schema contains table list like that</p>
  
  <pre><code>'prefix_A'
  'prefix_B'
  'prefix_C'
  'A'
  'B'
  'C'
  </code></pre>
  
  <p>Now i want to drop list of tables ,containing  table prefix like that 'Prefix_',But others table A ,B ,C will be remain same.</p>
  
  <p>How it is possible ?</p>
  
  <p>Thanks in Advance.</p>