magnusbakken

Untitled

May 24th, 2013
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.55 KB | None | 0 0
  1. SELECT
  2.   col.TABLE_NAME,
  3.   col.column_name,
  4.   display_raw(stat.low_value,col.data_type) AS low_val,
  5.   display_raw(stat.high_value,col.data_type) 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
  18. ORDER BY
  19.   col.TABLE_NAME, col.column_name;
Advertisement
Add Comment
Please, Sign In to add comment