I am unable to get me a comma separated list of column names, given a table name. Any references are appreciated.
So my end result should be a sql statement in oracle which when run, will give me a comma separated list of column names in a given table. (so I can copy paste the list elsewhere)
edit:
So if my table looks like this: table1(fieidl1,field2,field3)
I am looking to get a string like "field1,field2,field3"
so I can plug in to a separate sql statement to select the fields from the table in that order.
SET COLSEP ,
? – drumLISTAGG
works with 11g onwards. – Lalit Kumar B