Re: SQLPLUS: creating a text file with column header and tabel rows?

Thanx Jim for your answer.

>try "set pagesize 0" to get rid of repeated headers
but then I get no headline at all

What I want is a flat file like this

FAMILY_NAME|SUR_NAME|CITY|ZIPCODE|STREET Miller|John|Berlin|12290|Fleetstreet 12
Trueman|Sandy|3445|Hamburg|Lakestreet

and so on

But on long lines it looks currently like this

FAMILY_NAME|SUR_NAME|CITY|
ZIPCODE|STREET
Miller|John|Berlin|12290|
Fleetstreet 12
Trueman|Sandy|3445|
Hamburg|Lakestreet

even if I set linesize to a bigger value. The header I got more than once.

I am trying it that way because I want to export tablerows thru an view. The tables belong to another schema.

I am trying this under AIX5.2
Maybe smeone has an idea?

Regards
Carsten Received on Wed Aug 10 2005 - 03:11:37 CDT