|
|
Archives of the TeradataForum
Message Posted: Wed, 29 Jan 2003 @ 14:30:47 GMT
Subj: | | Result on one line rather than in column. |
|
From: | | Philippe VILLENEUVE |
Hello !
I have this SQL command
select a.ColumnName FROM DBC.Columns a WHERE a.DatabaseName='xxxx'
and a.TableName='zzzzz'
Result :
DATE_DEBU_VALD_INFO
CODE_ETAT_GENR
NUMR_ABNN_VIDT
DATE_ADHS
CODE_ABNN_ACTF
NATR_RESI_ABNN_VIDT
CODE_TARF
TYPE_CONT_VIDT
NUMR_PERS
CODE_PRDT_SERV
CODE_ORGN_FINN
how can i have the result on one line : DATE_DEBU_VALD_INFO,
CODE_ETAT_GENR, NUMR_ABNN_VIDT,....?
Best regards
Philippe VILLENEUVE
| |