Follow us: Subscribe via RSS Feed Connect on YouTube Connect on YouTube

Pages

Sunday, 5 February 2017

Query to Check for Existence Of Any Object In Database


The relevant query is as follows:


SELECT owner, object_type

FROM     all_objects

WHERE  object_name = ‘<OBJECT_NAME>’;


   ie. object_name = PO_HEADERS_ALL


            OWNER                        OBJECT_TYPE

            ----------------------------------------------------------

            APPS_APPDEMO          SYONONYM

            PODEMO                      TABLE
Share this article :

0 comments:

Post a Comment