how to delete histograms on a column

BEGIN
dbms_stats.delete_column_stats(
ownname=>'SH', tabname=>'SALES', colname=>'PROD_ID', col_stat_type=> 'HISTOGRAM');
END;
/