1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Query to find a all custom object's in oracle 11i

Discussion in 'Oracle Apps Technical' started by badram, Nov 16, 2011.

  1. badram

    badram Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Hi ,

    Can any one help me in writing a query for getting all custom object's in 11i which will help in migrating

    Thank's & Regards
    Badram
     
  2. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    While creating custom objects, companies follow some naming rules. Assuming that your object name starts with 'XX'
    The following query can help you out.

    Code (SQL):
    SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME LIKE 'XX%';

    All The Best