Directory Objects in plsql

ALL_DIRECTORIES (OWNER, DIRECTORY_NAME, DIRECTORY_PATH)
This view describes all directories accessible to the user.

SELECT * FROM ALL_DIRECTORIES;

DBA_DIRECTORIES(OWNER, DIRECTORY_NAME, DIRECTORY_PATH)
This view describes all directories specified for the entire database.

SELECT * FROM DBA_DIRECTORIES;

References

Oracle Doc