Simple way to get a file directory listing!

preview_player
Показать описание
No more Java or C programs. With an external table, you can easily get a directory listing of files on your database server.

Follow me!

Subscribe for new tech videos every week or check out the Podcast!

Music: Night Owl (Broke For Free), Kevin Mcleod (incomptech), Dyalla

#database #sql #utl_file
Рекомендации по теме
Комментарии
Автор

Much better than using Java like on earlier versions of Oracle

JimmyBrock
Автор

I m doing this for my mount points used% free% storage size

a.useronly
Автор

No it isn't 'simple'... You need to create your own batch file for Linux/Windows, have write permissions in the directory in some cases, error prone to date and file formats etc.
'Simple' would be an function in UTL_FILE; Like you say, 'the fist thing you do?' ... well in Oracle, 'create your own functionality because it it is not provided'. What about a UTL_FILE equivalent of 'DBMS_CLOUD.LIST_FILES' running on a Oracle directory?

studionl