Re: Why use ProC for spooling result sets to flat files when you can do the same thing in SQLPlus?

From: Rumpi Gravenstein <rgravens@xxxxxxxxx>
To: bwmyers@xxxxxxxxx, oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 1 Sep 2010 20:12:35 -0400

<snip>
So, is there any real advantage to using Pro*C over SQL*Plus to spool result
sets to flat files? I certainly don't want to become a Pro*C expert, so any
ideas would be greatly appreciated.
</snip>

If you are going to write from the RDBMS to the file system, you should also
consider using external tables.

Here's an article that describes how to do that:

http://www.oracle-developer.net/display.php?id=325


-- 
Rumpi Gravenstein

Follow-Ups:
- Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?
  - From: William Robertson

References:
- Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?
  - From: Bill Myers

Other related posts:

» Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- Bill Myers
» Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- Jared Still
» RE: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- Michael Dinh
» Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- John Piwowar
» Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- Bill Myers
» RE: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- Michael Dinh
» Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- Steve Baldwin
» Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- Bill Myers
» Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus? - Rumpi Gravenstein
» Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- Steve Baldwin
» Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- De DBA
» Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- De DBA
» Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- Bill Myers
» Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- Subodh Deshpande
» Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- William Robertson
» Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- Howard Latham
» RE: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- Bellows, Bambi (Comsys)
» Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- Greg Rahn
» RE: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- Goulet, Richard
» Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- Jared Still
» Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- Jeremy Schneider
» RE: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- Powell, Mark
» Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- Andreas Piesk
» Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- Bill Ferguson
» RE: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- Goulet, Richard
» RE: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- Powell, Mark
» Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- Bill Myers
» Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- Peter Hitchman
» Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?- Subodh Deshpande

Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?

Other related posts:

Re: Why use ProC for spooling result sets to flat files when you can do the same thing in SQLPlus?