0

Is it possible to use wildcard on renaming a file from a directory?

UTL_FILE.FRENAME (

   'EXT_DIR' IN   VARCHAR2,

   '%.CSV%'  IN   VARCHAR2,

   'EXT_DIR' IN   VARCHAR2,

   'WPP_ACCOUNT.CSV' IN   VARCHAR2,

   TRUE);
Kaushik Nayak
  • 30,772
  • 5
  • 32
  • 45
Nick
  • 117
  • 1
  • 9
  • There are some other ways to loop through the files in a file system : check this http://www.pafumi.net/SQL_Directory_Listing.html – Kaushik Nayak Jul 18 '18 at 04:06

1 Answers1

0

No, you can't do that. This is not a database call. You could create an external table, with a preprocessor directive that gives you the list of files in a directory, then put a FOR loop on top of that, but that's fairly complicated.

eaolson
  • 14,717
  • 7
  • 43
  • 58
  • I see, that is why on my other question unfortunately the external table im using is not working when I use preprocessor. – Nick Jul 18 '18 at 06:29