Additionally, you could use the Oracle supplied procedure
DBMS_UTILITY.TABLE_TO_COMMA if you need a CSV file.
sfaroult_at_oriole.com wrote:
>
> You have basically three means :
> o PL/SQL with UTL_FILE. You are limited by the line size. An advantage
> is that everything happens on the server (no data transfer across the
> network).
> o SQL*Plus spool. Works fine when used cleverly. Jared's dump.sql
> is a good example and is fast, I think I have seen others mentioned
> on www.lonyx.com
> o Third party products. Oriole has one, pdqout <plug>free for up to
> 250,000 rows starting with version 2.1 available next week</plug>,
> CA has one, BMC has one ...
Received on Fri Jan 12 2001 - 12:14:41 CST
