SQL Loader Control file

Hi,

Is there a way we can specify multiple delimiter in the FIELDS TERMINATED BY Clause?

Here is a sample control file..... The data to load may be delimieted either with a | or , or ?

Thanks in advance.........

CTL File

LOAD DATA INFILE 'datafile.dat'

INTO TABLE test_table_name

APPEND FIELDS TERMINATED BY ',' (

COL1                           INTEGER EXTERNAL,

COL2                            INTEGER EXTERNAL,

COL3              ...

--
Posted via http://dbforums.com