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 1: | Line 1: | ||
| + | If you have a table that contains groups of lists - such as the list of columns in tables - and you want to list the columns against their table name on one line rather than across several - such as: | ||
| + | |||
| + | {| class="wikitable" | ||
| + | |- | ||
| + | ! Table Name | ||
| + | ! Column Name | ||
| + | |||
| + | |- | ||
| + | |ISO_COUNTRY | ||
| + | |CODE,NAME | ||
| + | |||
| + | |} | ||
| + | |||
Creating a comma separated list from a table can be done by using the tree function sys_connect_by_path - this example creates a list of the columns in each table or view: | Creating a comma separated list from a table can be done by using the tree function sys_connect_by_path - this example creates a list of the columns in each table or view: | ||
<pre> | <pre> | ||
