Never let your sequence exceed your column precision. Here is simple way to generate a check..
select ds.sequence_name,
dtc.table_name,
dtc.column_name,
ds.last_number,
dtc.data_precision,
round(ds.last_number/power(10,dtc.data_precision),2)*100||'%' percent_used
from all_sequences ds,
all_tab_columns dtc
where ds.sequence_name like 'SEQ_'||trim(upper(dtc.column_name))
order by percent_used desc, sequence_name;
Hi,
ReplyDeleteThis is reall nice check you have just created. Can you explain me is it checking the column with same naming convention or it doesn't matter. Can you brief me little bit about it that what this check is really doing???
Thanks
TOM