How to easily access the file system from PLSQL ?
The goal is to perform an simple command like:
- DOS: dir
- LINUX: ls
and get the result as select.
Very good tool is offered by:
http://plsqlexecoscomm.sourceforge.net/
You need to download the PLSQL package from the web site above, install the PLSQL script and then perform the simple select:
select *
from table(file_pkg.get_file_list(file_pkg.get_file('/')))
Nessun commento:
Posta un commento