Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Confusion over Tables & public Synonyms

Sai SandeepAug 24 2018 — edited Aug 28 2018

Hi All,

Greetings for the day

I have small confusion over Tables& Public Synonyms.

Please find the below scenario,

I have Table and Public Synonym with same name (Employee) in same schema, if i run Select statement with from "Employee"  which will database take(Table/Public Synonym) and retrieve data? What if we are executing SQL from different schema, does remains same sequence or it vary?

Please provide the order/sequence ORACLE DB takes to execute above scenario.

Regards,

Sai Sandeep.

This post has been answered by Hans Steijntjes on Aug 24 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 25 2018
Added on Aug 24 2018
10 comments
2,391 views