title: Delete file from server using UTL_FILE.FRemove without knowing the file name
body: <p>I am a reporting analyst, who was asked to learn some PL/SQL to automate some processes.  So I am almost finished, with one step standing in the way. I have a package that </p>
  
  <ol>
  <li>Loads a table with a query I wrote.</li>
  <li>Exports the results from that table to a .txt file on the server with the     current_date tacked onto the file name .</li>
  </ol>
  
  <p>I am trying to delete the 3 files it creates using a wildcard, but I continually get errors such as "vendor_file.ia.*.txt is not defined": </p>
  
  <ul>
  <li>file_location is my path</li>
  </ul>
  
  <p>I can delete it no problem with:    </p>
  
  <pre><code>    utl_file.fremove(file_location,'vendor_file.ia.09.02.2015.txt');
      utl_file.fremove(file_location,'vendor_file.il.09.02.2015.txt');
      utl_file.fremove(file_location,'vendor_file.sd.09.02.2015.txt'); 
  </code></pre>
  
  <p>But obviously that won't delete it when it gets run next month. So am I missing a simple wildcard to search just for 'vendor_file.ia.*' And does the syntax look in Oracle?</p>
  
  <p>If I didn't provide enough information please let me know!</p>
  
  <p>Thanks a lot!</p>