Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using PL/SQL for non database files

3761854Aug 15 2018 — edited Aug 16 2018

This is probably a quick yes/no one but have struggled to find the answer...

Is it possible to use PL/SQL to read in a file off the network and then output results back out onto the network (without any DBA rights on any databases I might be able to connect to)?

As an example say I had a very big text file and wanted to filter certain records out of it I was wondering if PL/SQL could be used as a conduit to do so.  Read in the input file somehow, run the relevant select statement and then output a result file back onto the network without writing to any database.  Suppose a bit like the functionality something like FoxPro has.

Thanks in advance.

Paul

This post has been answered by Sven W. on Aug 15 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 13 2018
Added on Aug 15 2018
6 comments
550 views