devxlogo

Importing Tab-Delimited ASCII File with SQL Loader

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.

See also  5 Tips for Choosing the Right Medical Software for Your Practice
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist