regex - Is it possible to combine REPLACE with LIKE to replace multiple values in oracle database column -

this similar question here instead of replacing single value want replace multiple values matching pattern.

--create table create table my_table (column1 varchar2(10));  --load table insert my_table values ('test1'); insert my_table values ('test2'); insert my_table values ('test3'); insert my_table values ('test4'); insert my_table values ('test5'); insert my_table values ('lesson');    --this query replaces 'test1' blank select replace(column1, 'test1', ' ') my_table;  --now want replace matching values blank error select replace(column1, '%test%', ' ') my_table; --this throws below error.   --ora-00936: missing expression --00936. 00000 -  "missing expression" --*cause:     --*action: --error @ line: 19 column: 25 

running oracle database 11g enterprise edition release 11.2.0.1.0

i use regexp_replace.

select regexp_replace(column1,'test[[:digit:]]', ' ') my_table; 

regexp_replace