Re: Pro*C Example

From: Thomas Kyte <tkyte_at_oracle.com>
Date: 1 Sep 2002 08:27:40 -0700
Message-ID: <aktblc021g1@drn.newsguy.com>

In article <7e3fa619.0208311745.2e995b41_at_posting.google.com>, gwhubert_at_hotmail.com says...
>
>Thomas Kyte <tkyte_at_oracle.com> wrote in message
>news:<akqnnh021pg_at_drn.newsguy.com>...
>> In article <7e3fa619.0208301717.380e1648_at_posting.google.com>,
>> gwhubert_at_hotmail.com says...
>> >
>> >This is for Oracle 8.1.7 on Solaris
>> >
>> >Could someone point me to some Pro*C examples...
>>
>> see
>>http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:459020243348
>
>Thanks a bunch T.K., sounds like just what I need!
>
>By the way, would you expect dumping a query via Pro*C to be much
>faster than spooling via SQL*PLUS and why?
>
>Gene Hubert

Yes I would expect a specific, single purpose Pro*C program to be faster.

SQLPlus is a general purpose command line interface with bells and whistles.

My pro*c program has but one goal in life - dump data. No formatting, no processing, nothing.

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Sun Sep 01 2002 - 10:27:40 CDT