SHOW:
|
|
- or go back to the newest paste.
| 1 | select | |
| 2 | col.table_name, | |
| 3 | col.column_name, | |
| 4 | - | display_raw(stat.low_value,col.data_type) as low_val, |
| 4 | + | utl_raw.cast_to_number(stat.low_value) as low_val, |
| 5 | - | display_raw(stat.high_value,col.data_type) as high_val, |
| 5 | + | utl_raw.cast_to_number(stat.high_value) as high_val, |
| 6 | col.data_type | |
| 7 | from | |
| 8 | ALL_TAB_COL_STATISTICS stat | |
| 9 | join all_tab_columns col on | |
| 10 | stat.owner = col.owner and | |
| 11 | stat.table_name = col.table_name and | |
| 12 | stat.column_name = col.column_name | |
| 13 | where | |
| 14 | col.owner = 'INFOSOFT' and | |
| 15 | col.data_type = 'NUMBER' and | |
| 16 | col.data_precision = 5 and | |
| 17 | - | display_raw(stat.high_value,col.data_type) >= 32768 |
| 17 | + | utl_raw.cast_to_number(stat.high_value) >= 32768 |
| 18 | order by | |
| 19 | col.table_name, col.column_name; |
