Find the external table details along with dirctories

col OWNER for a20
col TABLE_NAME for a30
col DIRECTORY_PATH for a50
set lines 250 pages 100
select a.OWNER,TABLE_NAME,DEFAULT_DIRECTORY_NAME,DIRECTORY_PATH from dba_external_tables a, dba_directories b where a.DEFAULT_DIRECTORY_NAME=b.DIRECTORY_NAME order by a.OWNER;

or 
col TABLE_NAME for a30
col DIRECTORY_PATH for a50
set lines 250 pages 100
select distinct b.OWNER,DEFAULT_DIRECTORY_NAME,DIRECTORY_PATH from dba_external_tables a, dba_directories b where a.DEFAULT_DIRECTORY_NAME=b.DIRECTORY_NAME;