set linesize 300 column DIRECTORY_PATH format a80 select * from dba_directories order by DIRECTORY_NAME;