Is it possible to search column of a table for a particular value using function in Oracle? : I know it can be done like this, but I want to do it by using functions.

select * from *table_name*
where *column_name* like '%*STR*%';