[oracle] How to retrieve an Oracle directory path?

I created the following Oracle Directory csvDir:

create or replace directory csvDir as
 'd:\oracle\oradata\external_data\downloadedFiles';

Now, how can I retrieve the path from this csvDir alias?

There should be some system table that stores this path.

The ALL_DIRECTORIES data dictionary view will have information about all the directories that you have access to. That includes the operating system path

SELECT owner, directory_name, directory_path
  FROM all_directories

select directory_path from dba_directories where upper(directory_name) = 'CSVDIR'