Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Retrive directory content.

Status
Not open for further replies.
fmorel

fmorel

Programmer
Apr 24, 2002
123
CH
Hi all !

Does anyone know how to retreive the content of a directory created with "create directory ...". I just need to get the file list ("ls").

Using UTL_FILE or DBMS_LOB ?

Thanks for answers!
 
Sort by date Sort by votes
Hi,
You can use host commands directly by typing
sql>host ls
I am not sure of how to get the listing from the oracle directory.
Thanks & Regards,
DoubleH
 
Upvote 0 Downvote
Thanks,
In fact I would like to retrieve it in a PL/SQL block.

Regards
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

g7th
  • Locked
  • Question
ORA_EXCEL justify-content
Replies
0
Views
49
g7th
g7th
DanEvansJr
  • Locked
  • Question
Oracle Client on an Active Directory server? 1
Replies
1
Views
45
LKBrwnDBA
LKBrwnDBA
cecilcheah
  • Locked
  • Question
Upload Document to Local Directory
Replies
7
Views
48
Thargy
Thargy
Yarka
  • Locked
  • Question
Content DB
Replies
0
Views
31
Yarka
Yarka
sjh
  • Locked
  • Question
Oracle directory that points to a different server? 2
Replies
5
Views
159
sem
sem

Part and Inventory Search

Sponsor

Back
Top