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.