dba_directories_all.sql

-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Author       : Sameer S Choudhari
-- Description  : List all directories in the database order by directory_name.
-- Call Syntax  : @dba_directories_all.sql
-- Last Modified: 20/06/2017
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SET LINES 220 PAGES 49999
COLUMN owner FORMAT a30
COLUMN directory_name FORMAT a30
COLUMN directory_path FORMAT a100
SELECT *
FROM dba_directories
ORDER BY
  owner,
  directory_name;