magnusbakken

Untitled

May 24th, 2013
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.   col.TABLE_NAME,
  3.   col.column_name,
  4.   utl_raw.cast_to_number(stat.low_value) AS low_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.   utl_raw.cast_to_number(stat.high_value) >= 32768
  18. ORDER BY
  19.   col.TABLE_NAME, col.column_name;
Advertisement
Add Comment
Please, Sign In to add comment