If you want to save the query plan is necessary to set the variable:

INSERT03

=>setsr_plan.write_mode= true;

=>select a,bfrom test_tablewhere a= _p(1);

=>select a,bfrom test_tablewhere a= _p(1);

a | b

1 |1

Now plan for query from our table is saved with parameter. So,

if we enable saved plan in this table, this plan would be used for query

with any value for a, as long as this value is wrapped with_p()