Re: Flat file, non-fixed column dump of SELECT?
From: (wrong string) öström <lasse.sjostrom_at_telia.com>
Date: Mon, 25 Oct 1999 20:28:19 GMT
Message-ID: <D33R3.287$kvj.187160064_at_newsa.telia.net>
Date: Mon, 25 Oct 1999 20:28:19 GMT
Message-ID: <D33R3.287$kvj.187160064_at_newsa.telia.net>
And if you got a lot of columns a good start is the USER_TAB_COLUMNS-table
as an aid to fix
the SELECT-statement.
select column_name||','
from user_tab_columns
where table_name='YOUR_TABLE'
>SELECT COLUMNA||','||COLUMNB
>FROM YOURTABLE;
>
>This should do it. Don't forget to TO_CHAR any
>number or date columns.
>
>Simon Hedges
>Gloucester
>UK
>
>
Received on Mon Oct 25 1999 - 22:28:19 CEST