Re: sql loader help
- From: Jared Still <jkstill@xxxxxxxxx>
- To: andrew.kerber@xxxxxxxxx
- Date: Wed, 19 Aug 2009 09:12:08 -0700
On Wed, Aug 19, 2009 at 5:42 AM, Andrew Kerber <andrew.kerber@xxxxxxxxx>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
Other related posts:
