DBA Data[Home] [Help]

APPS.OKC_UTIL dependencies on ALL_HISTOGRAMS

Line 3099: from all_histograms

3095: l_percent number;
3096: begin
3097: begin
3098: select max(ENDPOINT_NUMBER) into l_percent
3099: from all_histograms
3100: where owner=p_owner
3101: and TABLE_NAME=p_table
3102: and COLUMN_NAME=p_column;
3103: exception

Line 3110: from all_histograms

3106: if (l_percent=0 or l_percent is NULL) then return 0;
3107: end if;
3108: begin
3109: select ENDPOINT_NUMBER into l_endpoint
3110: from all_histograms
3111: where owner=p_owner
3112: and TABLE_NAME=p_table
3113: and COLUMN_NAME=p_column
3114: and ENDPOINT_VALUE=p_value;

Line 3122: from all_histograms

3118: if (l_endpoint=0 or l_endpoint is NULL) then return 0;
3119: end if;
3120: begin
3121: select max(ENDPOINT_NUMBER) into l_startpoint
3122: from all_histograms
3123: where owner=p_owner
3124: and TABLE_NAME=p_table
3125: and COLUMN_NAME=p_column
3126: and ENDPOINT_NUMBER