Thread: schema

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    5
    Rep Power
    0

    Red face schema


    when a user in oracle, say user Db100, issues
    "select * from tblAbc",
    how does the oracle engine figures out which "tblABC" to read from?

    thnks
    mrk
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    68
    Rep Power
    12
    The book: "OCA/OCP Introduction to Oracle 9i SQL, Study Guide", says:

    When your code references an unqualified table, view, procedure, function or package, there are three places that Oracle will look for the referenced object, in this order:

    1. An object owned by the current user
    2. A private synonym owned by the current user
    3. A public synonym

    Regards,
    Dan

IMN logo majestic logo threadwatch logo seochat tools logo