Re: How to dump the database to file in program?

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Thu, 11 Nov 1999 14:42:36 -0800
Message-ID: <80fgqg$3r5$1@plo.sierra.com>

In your sql*plus session,

set pagesize 0
set linesize 1500
set space 0
set trimout on
set feedback off

select * from any_table_you_pick

and look at the results.

If you spool this output to a file, you are very close. Now add your where clause (if necessary) or create a view (if you have to do this a lot)
(we also use SUBSTR(TO_CHAR(a_date_field,'MM/DD/YYYY'),1,10) to change dates into a more friendly format.)

<arko3790_at_my-deja.com> wrote in message news:80b04f$6cf$1_at_nnrp1.deja.com...
> hi all:
>
> I want to dump several tables to text files
> in my Pro.C program, but it seemed there is not
> any oracle functions..
>
> Then i have to use cursor to read all records out,
> then put to file.
>
> Could anyone give me a better suggestion?
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Nov 11 1999 - 16:42:36 CST