Creating Comma Seperated Lists
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page Creating Comma Seperated Lists
| Line 26: | Line 26: | ||
order by owner,table_name | order by owner,table_name | ||
</pre> | </pre> | ||
| - | ...and this one puts | + | ...and this one puts the columns in alphabetical order: |
<pre> | <pre> | ||
select owner,table_name,max(ltrim(sys_connect_by_path(column_name,','),',')) Columns | select owner,table_name,max(ltrim(sys_connect_by_path(column_name,','),',')) Columns | ||
