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

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 25 2018

Added on Aug 24 2018

#11g, #12c, #database, #oracle, #plsql, #sql, #table

10 comments

2,395 views