Re: Generate flat file with fixed layout from Oracle tables

Hi Paul,

  I apologize for not giving more details on the issue. The database version Oracle 9i Version 9.2.0.1 and DDL for the table is as follows:

   CREATE TABEL CUSTOMER
   (

     CUSTOMER_ID   NUMBER,
     ACCOUNT_NUM   NUMBER,
     PHONE_NUM     NUBMER,
     EMAIL         VARCHAR2(100),
     V_FLAG        CHAR(1),
     INPUT_DATE    DATE

  The table has over 2 million rows and data from all the columns need to be output to the fixed-length flat file.

  Thanks.

  Nick

Paul wrote:
> "nickli" <ningli2000_at_hotmail.com> wrote:
>
>
> > I am trying to generate a flat file with the following layout from
> > an Oracle table:
>
>
> Crystal ball is in for repairs. What is the DDL of this original
> table?
>
>
> Paul...
>
>
> > Nick
>
>
> --
>
> plinehan __at__ yahoo __dot__ __com__
>
> XP Pro, SP 2,
>
> Oracle, 9.2.0.1.0 (Enterprise Ed.)
> Interbase 6.0.1.0;
>
> When asking database related questions, please give other posters
> some clues, like operating system, version of db being used and DDL.
> The exact text and/or number of error messages is useful (!= "it didn't work!").
> Thanks.
>
> Furthermore, as a courtesy to those who spend
> time analysing and attempting to help, please
> do not top post.
Received on Sat Aug 13 2005 - 12:38:06 CDT