RE: Different ways to transfer data in a table to a FLAT file

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Fri, 12 Jan 2001 09:26:50 -0800
Message-Id: <10739.126526@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C07CBC.D8F7ACA0
Content-Type: text/plain;

charset="iso-8859-1"

> -----Original Message-----
> From: Sankaranarayanan, Ramasubramanian
> [mailto:Ramasubramanian.Sankaranarayanan_at_compaq.com]
> Sent: vendredi, 12. janvier 2001 07:21
> 
> Please suggest me a different ways to transfer data from the 
> table to a FLAT
> file...

The obvious ways:

Easiest way - use SQL*Plus select statement, with the appropriate SQL*Plus SET commands, to obtain a flat file.
Use a PL/SQL program with the UTL_FILE package.
Use a Pro*C program to read in the data and create a flat file.

I now await the more learned comments of people with greater experience, who will suggest other possibilities.

any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer.

Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

------_=_NextPart_001_01C07CBC.D8F7ACA0
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2652.35">
<TITLE>RE: Different ways to transfer data in a table to a FLAT =
file</TITLE>
</HEAD>
<BODY>

> -----Original Message-----
 > From: Sankaranarayanan, Ramasubramanian
 > [<A =

HREF=3D"mailto:Ramasubramanian.Sankaranarayanan_at_compaq.com">mailto:Ramas= ubramanian.Sankaranarayanan_at_compaq.com</A>]
 > Sent: vendredi, 12. janvier 2001 07:21
 > 
 > Please suggest me a different ways to transfer =
data from the 
 > table to a FLAT
 > file...


The obvious ways:


a) Easiest way - use SQL*Plus select statement, with =
the appropriate SQL*Plus SET commands, to obtain a flat file.
 b) Use a PL/SQL program with the UTL_FILE =
package.
 c) Use a Pro*C program to read in the data and =
create a flat file.


I now await the more learned comments of people with =
greater experience, who will suggest other possibilities.


------
 any ignorant comments made are the sole =
responsibility of J. R. Kilchoer and should not reflect adversely upon = my employer.

 
 Jacques R. Kilchoer
 (949) 754-8816
 Quest Software, Inc.
 8001 Irvine Center Drive
 Irvine, California 92618
 U.S.A.
 <A HREF=3D"http://www.quest.com" =
TARGET=3D"_blank">http://www.quest.com</A> Received on Fri Jan 12 2001 - 11:26:50 CST