Find the Oracle object by name

If You don’t remember exactly the name of the view or table, so this query is for You:

col SHORT_OBJECT_NAME FOR a30
SELECT
SUBSTR( ob.OBJECT_NAME,1,30)"SHORT_OBJECT_NAME",
SUBSTR( ob.OWNER,1,15)"SHORT_OWNER" ,
ob.OBJECT_TYPE,ob.CREATED
FROM dba_objects ob
WHERE object_name LIKE UPPER('%&template%') escape '\'
order by 1,2;

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>