Re: No SQL - Unloader in Oracle 9i

Andrew Mobbs wrote:
> >Nevertheless back to the main point of this thread, better data
> >unloading. Yes it would be nice if Oracle provided a data unloader
> >utility, but you can use SQL to mimic some of its desired features
> >such creating comma delimited output. I lost a better version but
> >here is some SQL to generate a CSV file:
> There's a good version of this by Jared Still:
> http://www.cybcon.com/~jkstill/util/zips/dump.sql

I created a Pro*C program to do this. It's called "dosql". It has options to generate sqlldr control- and/or data-files, or straight into several other formats (html, tbl/nroff, tex, sql).

To unload database structures as SQL text there's "sqlexp", also in Pro*C.

Both are commandline utilities. The source code and some precompiled binaries are on http://www.dondorp.com/oratools.html

        E. Received on Sat Jun 30 2001 - 18:30:36 CDT