Concatenation in GROUP BY
408856Jan 29 2004 — edited Jan 29 2004Hi All,
I would like format an output of following query in such a way to see concatenated COLUMN_NAME after grouping by TABLE_NAME and CONSTRAINT_NAME. Please can anybody suggest me how to do that in a SQL query.
--------------
select table_name, constraint_name, column_name
from ALL_CONS_COLUMNS
WHERE OWNER = 'RAJ'
and constraint_name not like 'FK%'
and constraint_name not like 'SYS%'
and constraint_name not like 'CK%'
order by table_name, constraint_name, position
--------------
Thanks,
Rajendra