I'm trying to develop a couple of scripts to drop partitions one for monthly and the other for dailies for more than one table. However I'm having issues with high_value. I have the following that I put together using a packaged function written by Tom Kyte but I need to omit the high_value results so I only get the drop statements. Any help is appreciated.
create or replace
package system.long_help
authid current_user
as
function substr_of
( p_query in varchar2,
p_from in number,
p_for in number,
p_name1 in varchar2 default NULL,
p_bind1 in varchar2 default NULL,