Oracle查询存储过程、视图、触发器等内容是否包含某一个指定的文本
SELECT *
FROM ALL_SOURCE
WHERE
UPPER(TEXT) LIKE UPPER('%insert into AA_yu_pay_detail%') and owner='AA_USER';
SELECT *
FROM ALL_SOURCE
WHERE
UPPER(TEXT) LIKE UPPER('%insert into AA_yu_pay_detail%') and owner='AA_USER';