Skip to Main Content

Analytics Software

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!

File to SQL with joker input file

849400Jun 24 2011
Hi,

I want to load a file which i dont know the exact name

I use the LKM File to Sql which give :
select COL C1_COL,
COL C2_COL,
COL C3_COL
from TABLE
/*$$SNPS_START_KEYSNP$CRDWG_TABLESNP$CRTABLE_NAME=FICENTSNP$CRLOAD_FILE=/fildername/File_Name.txtSNP$CRFILE_FORMAT=FSNP$CRFILE_SEP_FIELD=0x0009SNP$CRFILE_SEP_LINE=0x000ASNP$CRFILE_FIRST_ROW=0SNP$CRFILE_ENC_FIELD=SNP$CRFILE_DEC_SEP=SNP$CRSNP$CRDWG_COLSNP$CRCOL_NAME=COLSNP$CRTYPE_NAME=STRINGSNP$CRLINE_OFFSET=1SNP$CRLENGTH=4000SNP$CRPRECISION=4000SNP$CR$$SNPS_END_KEY*/

At the place of the file name "File_Name.txt", i would like to write something like :
File_*.txt
or File_????.txt

Is it possible to use a character joker to remplace "Name" in the input fiel name ?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 22 2011
Added on Jun 24 2011
0 comments
188 views