Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sql Loader separator
- Thread starter claude69
- Start date
According to the SQL*Loader documentation, this isn't possible. Oracle 8i has some new features when specifying delimiters, including multi-character delimiters. However, the ability to use more than one delimiter doesn't appear to be an option.
- Thread starter
- #3
It's possible to specificate more separetor having row termineted in this way
load data
APPEND
into table SEB_PER
trailing nullcols
(EVENT_DATE DATE "YYYYMMDD" TERMINATED BY WHITESPACE,
TIME CHAR TERMINATED BY ';',
Tools CHAR TERMINATED BY ':')
load data
APPEND
into table SEB_PER
trailing nullcols
(EVENT_DATE DATE "YYYYMMDD" TERMINATED BY WHITESPACE,
TIME CHAR TERMINATED BY ';',
Tools CHAR TERMINATED BY ':')
- Status
