Re: Exporting to a .csv file

From: Paul Drake <paled_at_home.com>
Date: Sat, 14 Apr 2001 23:19:48 GMT
Message-ID: <3AD8DAF3.F67B6BB0_at_home.com>


desc dbms_utility;

PROCEDURE TABLE_TO_COMMA

 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 TAB                            TABLE OF VARCHAR2(227)  IN
 TABLEN                         BINARY_INTEGER          OUT
 LIST                           VARCHAR2                OUT

lots of stuff in the %ORACLE_HOME\rdbms\admin directory. perform a "find" against your local file system sometimes - faster than launching a browser, and does not require Java.

hth,

Paul

Jeff Boyer wrote:
>
> Hello everyone,
>
> Can anyone tell me how to Export my database to a comma separated value
> file. I have done some reading on the net about this but everywhere I go
> they say you need to spool from within SQL*Plus with a custom script, but
> there are no examples of this custom script. Can anyone help me?
>
> Thanks,
> Jeff
Received on Sun Apr 15 2001 - 01:19:48 CEST

Original text of this message