Re: This is a question about the concatenation symbol "||"
From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Sat, 03 Jul 2004 23:26:23 +0200
Message-ID: <o19ee09m13ktv9albesm81i2jaibbd7omv_at_4ax.com>
Date: Sat, 03 Jul 2004 23:26:23 +0200
Message-ID: <o19ee09m13ktv9albesm81i2jaibbd7omv_at_4ax.com>
On 3 Jul 2004 11:22:27 -0700, ohahaahr_at_hotmail.com (Ole Hansen) wrote:
>The reasen why a want to write "select *||" is, that I have a table
>with more than 200 fields, and I need to export them all to a
>csv-file. I don't want to write "field1||','||field2||',' ..." for all
>200 fields.
>
>Is there a smart way to do this ???
>
>I use SQLPlus on Oracle 9i.
The most important advise would be to normalize your design. If you really don't want to suffer the consequences of your design, generate your statements using the dictionary view user_tab_columns.
-- Sybrand Bakker, Senior Oracle DBAReceived on Sat Jul 03 2004 - 23:26:23 CEST