Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Nov 23, 1999

Importing Tab-Delimited ASCII File with SQL Loader

Question:
As a novice SQL Loader user, I have imported a comma-delimited ASCII file into an Oracle database (Unix) using >sqlldr and specifying the delimiter as a comma.

I now have a tab-delimited file to import and have not yet found a way of designating the tab character(s) as the delimiter. Is there a way, or do I need to convert the tab-delimited file to a comma-delimited file first?

Answer:
I'm not up on SQL Loader, but I think the tab character is ASC(14) or ASC(17), so if there is a way to designate the ASCII value of the key that represents the delimiter, then you'll be able to do it directly.

Failing that, you could, as you suggest, replace the delimiters, but I loathe changing data for conversion because you never know what you're going to overwrite or change inadvertently.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date