title: Oracle - PL/SQL: How to read from changeable file names in external tables?
body: <p>I need help please. I want to create a table using PL/SQL that contains sysdate in its name? For example, table_name_sysdate?</p>
  
  <p>I am trying to create an external table that will read from a .csv file and the file name I want to read from, its name consists of constant (table_name) and the date (sysdate). This file name is changeable daily according to the date. I don't know how to create the mechanism to load from daily changeable file names.</p>
  
  <p>This is my code, I don't know what to put inside the brackets with question marks. </p>
  
  <pre><code>create table ext_table_1
  (med_name varchar2(20),
  cost integer)
  organization external
  (type ORACLE_LOADER 
  default directory orders
  access parameters
  (records delimited by newline
  fields terminated by ',')
  location (???)
  reject limit 200;
  </code></pre>