title: How to retrieve an Oracle directory path?
body: <p>I created the following Oracle Directory <code>csvDir</code>:</p>
  
  <pre><code>create or replace directory csvDir as
   'd:\oracle\oradata\external_data\downloadedFiles';
  </code></pre>
  
  <p>Now, how can I retrieve the path from this <code>csvDir</code> alias?</p>
  
  <p>There should be some system table that stores this path.</p>