Monday, October 22, 2018

search oracle object (stored procedure , function....etc)

Query to search object by name

select * from ALL_OBJECTS
where OBJECT_NAME like '%CM_RT004_MOWE%'

ref:
https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2005.htm#i1583352

No comments:

Post a Comment