Re: sql loader help

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 19 Aug 2009 09:12:08 -0700
Message-ID: <bf46380908190912h685d6014r4aba63a9f31489d4_at_mail.gmail.com>

On Wed, Aug 19, 2009 at 5:42 AM, Andrew Kerber <andrew.kerber_at_gmail.com>wrote:

> Well, in this case, since it is a text file, I would recommend using a text
> editor on it before running sql loader. Some Unix guys could probably also
> give you a one line command to do it. Dont focus on Oracle as the only
> solution to the problem.
>

As you say, that should be a simple job for sed/

Also, if it allows using 'direct' mode on large files, the time with sed will be worthwhile.

That 'sed', I would probably use Perl. :)

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 19 2009 - 11:12:08 CDT