CODE EXAMPLE FOR SQL

oracle create directory

CREATE [OR REPLACE] DIRECTORY directory_name AS 'path_name';

SELECT * FROM DBA_DIRECTORIES WHERE DIRECTORY_NAME LIKE '%MY_PATH%';