All fields delimited by commas

[Jalr2003]

I have a table that has a lot of columns and I want to have
my results delimited by commas.

I now I can do something like this:

Select
FIELD1 || ',' ||
FIELD2 || ',' ||
*
*
*
FIELD(n-1) || ',' ||
FIELDn
FROM
TABLE

Is there a way to make a select * statement obtaining the same result?

Thanks,

Jalr2003

 

[BJCooperIT]

If you are using SQL*Plus in Oracle you can:

SQL> set head off
SQL> set colsep ,
SQL> select * from cat where rownum=1;

MY_TABLE                      ,TABLE
SQL>

Hope this helps!

select * from Life where Brain is not null

Consultant/Custom Forms & PL/SQL - Oracle 8.1.7 - Windows 2000
[sup]When posting code, please use TGML to help readability. Thanks![sup]