Santhosh Reddy Podduturi, November 25, 2016 - 5:12 am UTC
What is meant by inside to Outside?are these relates to any locations of namespace in oracle architecture?
November 25, 2016 - 8:03 am UTC
1) is "XXX" an object (including synonym) in my schema
2) if not, then is there a public synonym called XXX
Inside to outside name resolution
Subhrajit Banik, November 25, 2016 - 7:07 am UTC
In a SQL statement Oracle database attempts to qualify the object name referenced in the following order-
1)In the current schema the database searches for an object whose name matches with the referenced object name. If not then:
2)The database searches for a public synonym which matches with the referenced object name. If not then:
3)The database searches for a schema whose name matches with the referenced object name. If a schema is found then the database proceeds with Step-2(i.e. if the object name has two pieces like SCOTT.EMP where SCOTT will be treated as the first piece and EMP the second.)and after proceeding with Step-2 from Step-3 if no result is found the database returns an error.
If the Step-3 fails itself then also the database returns an error.
Now with respect to the above example in consideration to the 3 Steps, 'San' and 'Sam' are already found as objects in the current schema while for 'Pt' Step-2 is followed and hence the result.
November 25, 2016 - 8:03 am UTC
nice input