Because it's faster. SQL*Plus is not very efficient when it comes to formatting. Tom Kyte had a good example (that I even use) called array_flat (http://asktom.oracle.com/~tkyte/flat/index.html) but the link no longer works. More discussion of it here though: http://asktom.oracle.com/pls/asktom/f/f?p=100:11:0::::P11_QUESTION_ID:74310961923056 On Wed, Sep 1, 2010 at 3:23 PM, Bill Myers <bwmyers@xxxxxxxxx> wrote: > In my previous post, > //www.freelists.org/post/oracle-l/Any-valid-security-concerns-using-Data-Pump-over-conventional-expimp, > I mentioned that the DBAs at my new job use Pro*C to export data to flat > files. So I asked one of them in a meeting: "why not use SQL*Plus instead?" > Response after a long awkward stare: "you tell me". I have searched the > forums and docs to no avail (besides maybe some speed advantage). > > 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. > > Thanks in advance. > Bill > 9i OCA/10g OCP DBA > -- Regards, Greg Rahn http://structureddata.org -- //www.freelists.org/webpage/oracle-l
