Script: directories.sql

-- -----------------------------------------------------------------------------------
        -- Author       : Pavan Yennampelli
    -- Description  : Displays information about all directories.
    -- Requirements : Access to the DBA views.
    -- Call Syntax  : @directories
     -- -----------------------------------------------------------------------------------
    COLUMN owner FORMAT A20
    COLUMN directory_name FORMAT A25
    COLUMN directory_path FORMAT A50

    SELECT *
    FROM   dba_directories
    ORDER BY owner, directory_name;