Re: How to create a Cobol flatfile in sqlplus

Martin Haltmayer wrote:
>
> You can specify that the column separator is an empty string.
>
> create table mstest (
> t varchar2 (5)
> , ii number (7, 2)
> , i number (3)
> )
> /
>
> insert into mstest (t, ii, i) values ('M', 7000 + 77/100, 49);
> insert into mstest (t, ii, i) values ('K', 17000 + 17/100, 59);
>
> set colsep ''
> set pagesize 0
> set trimspool on
>
> column ii format a7
> column i format a3
>
> select
> t
> , to_char (ii * 100, 'FM0999999') as ii
> , to_char (i, 'FM099') as i
> from
> mstest
> /
>
> yields
>
> M 0700077049
> K 1700017059
>
> Martin
>
> Manfred Friedrich wrote:

...

Thanks Martin. It works!

Manfred Received on Sun Jun 25 2000 - 00:00:00 CDT