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!

Register Log in
  • Congratulations strongm 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

Status
Not open for further replies.
claude69

claude69

Technical User
Jan 30, 2003
15
IN
Hi guy there is some people that can tell me if inside the control file is possible to specificate more then one separator
Ex FIELDS TERMINATED BY ';' and FIELDS TERMINATED BY ':'

Thanks
Claude
 
Sort by date Sort by votes
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.
 
Upvote 0 Downvote
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 ':')


 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
389
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
2K
carp
carp
annie1975
  • Locked
  • Question
sql script in an cron job script failing
Replies
3
Views
171
carp
carp
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
195
Livia8
Livia8
rk68
  • Locked
  • Question
SQL Loader -Field in data file exceeds max length
Replies
1
Views
208
rk68
rk68

Part and Inventory Search

Sponsor

Back
Top