declare res number; begin for baslin IN ( select sql_handle, plan_name from dba_sql_plan_baselines where sql_text like 'select%from xyz%' and parsing_schema_name = user ) loop res := dbms_spm.drop_sql_plan_baseline(baslin.sql_handle, baslin.plan_name); end loop; end; /