sqlldr : infile file name with joker
849400Jun 24 2011 — edited Jun 27 2011Hi,
I want to use the SQL*Loader with an input file which I don't know the exact name.
However, I can't use "INFILE *" because there is several files and only one is needed.
For exemple :
I've got 2 files in a folder AAA123.txt and AAA456.txt
I would like to lauch sqlldr with something like this :
AAA1*.txt or AAA1??.txt or ... ?
and it will load the file AAA123.txt
Is it possible ?
thanks