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 34: | Line 34: | ||
group by owner,table_name | group by owner,table_name | ||
order by owner,table_name | order by owner,table_name | ||
| + | |||
| + | OWNER TABLE_NAME COLUMNS | ||
| + | ----- ------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ||
| + | SYS DBA_TABLESPACES TABLESPACE_NAME,BLOCK_SIZE,INITIAL_EXTENT,NEXT_EXTENT,MIN_EXTENTS,MAX_EXTENTS,MAX_SIZE,PCT_INCREASE,MIN_EXTLEN,STATUS,CONTENTS,LOGGING,FORCE_LOGGING,EXTENT_MANAGEMENT,ALLOCATION_TYPE,PLUGGED_IN,SEGMENT_SPACE_MANAGEMENT,DEF_TAB_COMPRESSION,RETENTION,BIGFILE,PREDICATE_EVALUATION,ENCRYPTED,COMPRESS_FOR | ||
| + | SYS DBA_TABLESPACE_GROUPS GROUP_NAME,TABLESPACE_NAME | ||
| + | SYS DBA_TABLESPACE_THRESHOLDS TABLESPACE_NAME,CONTENTS,EXTENT_MANAGEMENT,THRESHOLD_TYPE,METRICS_NAME,WARNING_OPERATOR,WARNING_VALUE,CRITICAL_OPERATOR,CRITICAL_VALUE | ||
| + | |||
| + | |||
| + | |||
| + | |||
</pre> | </pre> | ||
| + | |||
| + | |||
...and this one puts the columns in alphabetical order: | ...and this one puts the columns in alphabetical order: | ||
<pre> | <pre> | ||
