0

I have 150 odd csv files but there file name may vary. so i want to know whether in external table concept can we use *.csv where we provide file name list.

LOCATION (*.csv)

lobh
  • 33
  • 7

2 Answers2

2

According to this article, you can do it from 12c Release 1 (not tested):

A number of minor usability improvements have been made to the ORACLE_LOADER access driver to make external table creation simpler. The LOCATION clause now accepts wildcards. An "*" matches multiple characters, while a "?" matches a single character.

LOCATION ('emp_ext*.dmp')

LOCATION ('emp_ext?.dmp')
Aleksej
  • 22,443
  • 5
  • 33
  • 38
-1

From the docs:

The LOCATION clause lets you specify one or more external data sources. Usually the location_specifier is a file, but it need not be. Oracle Database does not interpret this clause. It is up to the access driver to interpret this information in the context of the external data.

So what happened when you tested it for yourself?

EdStevens
  • 3,708
  • 2
  • 10
  • 18