Search text in Oracle DB; Returns all types of Oracle function;

 Select * from ALL_SOURCE  where TEXT LIKE '%Approval%'