DBA Data[Home] [Help]

FUNCTION: SYS.GET_STATS_EXTENSION

Source


1 function get_stats_extension(
2   colrowid rowid)  return clob is
3   extn     long;
4   extnclob clob;
5 begin
6 
7   select
8     c.default$ into extn
9   from sys.col$ c
10   where c.rowid = colrowid;
11 
12   extnclob := extn;
13 
14   if (substr(extnclob, 1, 20) = 'SYS_OP_COMBINED_HASH') then
15     return substr(extnclob, 21);
16   else
17     return '(' || extnclob || ')';
18   end if;
19 
20 end get_stats_extension;