CODEWITHSUNDEEP
oracle-databasesynonym
neorc
neorc

Reputation: 277

How to access to the public synonym when there's another object with the same name in current schema?

Someone creates a public synonym for me to access, but I already has a table which has the same name as that public synonym. How can I access to it?

Upvotes: 0

Views: 3166

Answers (1)

Yahia
Yahia

Reputation: 70369

Use "PUBLIC" as the schema name, and the quotation marks are required.

Upvotes: 1

Related Questions