Using this query:
select
column_name
from
cols
where
table_name = 'PAYMENT_PROPOSAL_REP'
order by
column_id
I can see a list of columns in a table.
Rather than a long list going down the page:
COL1
COL2
COL3
COL4
I would like to create a single list, separated by commas like this:
COL1, COL2, COL3, COL4
I am sure XMLSEQUENCE can be used but would like guidance please.
I have read up and still have no joy!