Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Hierarchy of how table_name is resolved
Hi All,
I cannot seem to find in any docs on how Oracle determines resolution of table to access.
For ex say I have the following:
Public synonym name test_table
Private synonym under rick account name test_table.
Rick owns a table name test_table
If Rick does select * from test_table;
what order does oracle use to resolve?
The obvious is the following but not sure.
![]() |
![]() |