Re: Why use Pro*C for spooling result sets to flat files when you can do the same thing in SQL*Plus?
- From: Howard Latham <howard.latham@xxxxxxxxx>
- To: william@xxxxxxxxxxxxxxxxxxxx
- Date: Thu, 2 Sep 2010 09:09:56 +0100
In Pro C it is easier to supress New Lines Form Feeds ETC. But its not
impossible in SQLPLUS
On 02/09/2010, William Robertson <william@xxxxxxxxxxxxxxxxxxxx> wrote:
> Writing to external tables is a database to database transfer method
> using a non-human-readable binary format. I very much doubt that is what
> the Pro*C program is used for - most likely it is used to dump data to
> comma-separated ASCII text, which you can't do with external tables.
>
> Possibly they have a Pro*C app that's convenient and reusable? Just
> guessing.
>
>
> -------- Original Message --------
> Subject: Re: Why use Pro*C for spooling result sets to flat files when
> you can do the same thing in SQL*Plus?
> From: Rumpi Gravenstein <rgravens@xxxxxxxxx>
> To: bwmyers@xxxxxxxxx, oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
> Date: 2/9/10 01:12
>> <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.
>>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Howard A. Latham
Sent from my Nokia N97
--
//www.freelists.org/webpage/oracle-l
Other related posts:
