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.
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
