Re: specify layout in txt file using utl

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Wed, 31 Jul 2002 08:43:50 +0200
Message-ID: <ai814p$12dt96$1@ID-152732.news.dfncis.de>

> And this is the txt file:
>
> Level Object Number Object Count
>
> 00TESA02 A020 2
> 00TESA02 2
> 03GILA00 AA01 2
> 03GILA00 AA12 2
> 91GENA00 A07 2
> 91GENA00 A22B 2
> 91GENA00 A29A 2
> 91GENA00 A32 2
>
> Anyone can help me please??
>
> Thanks in advance.

I guess You want a formatted output to find column-like text. You can use LPAD and RPAD built-in functions in PL/SQL to acheive it. You may use it for any variable, and it should be fine. Received on Wed Jul 31 2002 - 01:43:50 CDT

Re: specify layout in txt file using utl_file