-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ -- 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;