It depends...
SQL itself doesn't support such a mechanism, but it would seem likely to me that using extproc and/or java stored procedures one might be able to do this. It does sound like a nice enhancement request for UTL_FILE to me.
cheers
On 9/19/06, Wojciech Skrzynecki <wojciech.skrzynecki@xxxxxxxxx> wrote:
I have question about directory which is created by command: "create directory ....."
Is it possible to list contents of directory from sql. If yes could you give me answer.
Thanks for help.
-- Wojciech Skrzynecki Database Administrator
-- Niall Litchfield Oracle DBA http://www.orawin.info