How do I read files from a certain directory with PL/SQL code, where the file name is variable , but always starting with a specific pattern.
My program must interface with another system which reads files in
a directory on the server. UTL_FILE only reads a file when you
know the name of the file, but I don't know the name in advance.
But, the file name starts with a specific set of alphabets always.
Example: CAS********
The CAS is always common and the next set of letters are variable.
The platform is Windows
Oracle version : Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
Thanks in advance.