Re: How to get the complete utl_file_dir list

In article <4d32d1be.0407230503.3bf0117b_at_posting.google.com>, Andre says...
> Hello All,
>
> With the command:
> CREATE DIRECTORY LOG_DIR as =3Fc:\MyDirectory';
> I have created several directories in my oracle 9.2 database
> CREATE DIRECTORY LOG_DIR1 as =3Fc:\MyDirectory1';
> CREATE DIRECTORY LOG_DIR2 as =3Fc:\MyDirectory2';
> CREATE DIRECTORY LOG_DIR3 as =3Fc:\MyDirectory3';
>
> But is there a way to do a select so I can see all these mappings?
> When I execute select * from v$parameter where name = 'utl_file_dir';
> I only get one record, and no directory is there.....
>

SQL> select * from all_directories;

-- 

jeremy