Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


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 :


  1. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check for Never Before Offers and Discount Coupon Codes.