SQL> select distinct name from user_source where upper(type)='PROCEDURE' and upp
er(text) like '%TABLENAME%';
NAME
------------------------------
SP_ABC
SP_BCD
SP_XYZ
SP_LMD
SP_WEEK_ABC
SP_WEEK_XYZ
er(text) like '%TABLENAME%';
NAME
------------------------------
SP_ABC
SP_BCD
SP_XYZ
SP_LMD
SP_WEEK_ABC
SP_WEEK_XYZ
No comments:
Post a Comment