Find all objects containing specific text in Oracle or all resource text

SELECT * FROM ALL_source WHERE UPPER(text) LIKE upper('%SUM(PROV_GR_AMT)%')

Easy way to change/update the oracle table column datatype without pain

ALTER TABLE es.response ADD approval_amount1 number(12,2); UPDATE es.response SET approval_amount1 = approval_amount; ALTER es.response MODIFY approval_amount (12,2); UPDATE es.response SET approval_amount=approval_amount1; ALTER TABLE es.response DROP COLUMN approval_amount1;