Re: export data out of Oracle DB

IMHO using a report generator like Crystal Reports with its export functions is far easier than using sql - Besides, you will need a good report writer to use with Oracle ( unless you really like theirs )

Check out crystal at www.seagatesoftware.com/crystalreports/  ( I think ).

John Greco

"Paull Scrivens" <pscriv_at_premier.co.uk> wrote:

>Hi Leslie,
>
>Why not put your criteria into a query and run via SQL*Plus, spooling the
>output to an operating system file.
>You can then "import" this file using SQL*Loader.
>
>Hope this is useful.
>
>Paul.
>
>L. Tseng <lesliet_at_u.washington.edu> wrote in article
><5qdigq$bh4_at_nntp6.u.washington.edu>...
>> Hi,
>>
>> Does anyone know if there is a utility that can export/import data
 from/to a table
>> using some criteria like in a where clause? Oracle's export/import
 utility can only
>> export/import ALL the data from/to a table and they don't work with a
 view.
>> For example I want to export part of a 10000 row table basing on a
 timestamp colume,
>> how can this be done?
>>
>> Thanks,
>>
>> Leslie
>>
Received on Mon Sep 29 1997 - 00:00:00 CDT