Re: Extracting Data From Oracle

This is fairly trivial to do using Sqlplus

eg.

	table fred
		x	number
		y	date

Select x||','||y from fred;

There also numerous more sophisticated ways of doing this depending the scale of your problem and the tools you have available.

Charles D DeVries <cdevries_at_link.com> wrote in article <33A585EF.DAF19651_at_link.com>...
> Maybee this is a RTFM but I sure can't find it. We have recently
> migrated an application from a Sybase database to an Oracle database for
> the maintenance tool. Due to several requirements for the data we still
> have the need to extract the data from Oracle and reimport it into
> Sybase on a nightly basis. I have yet to be able to figure out how to
> get data out of Oracle in a CSV type format for reimport.
>
Received on Mon Jun 16 1997 - 00:00:00 CDT