Re: How to access Synonym when it has same name as that of a Table

From: Frank van Bortel <>
Date: Mon, 24 Dec 2007 14:46:34 +0100
Message-ID: <3e44c$476fb839$524b5c40$> wrote:

> When execute the SQL ' Select * from BE_FRIEND' it always returns the
> data in the table. How to distinguish between a Table and a Synonym?

Not - that is the purpose of a public synonym.

If you are referring to the object type (as in "I want to know if be_friend ia a table, or a synonym or both"), then query the all_objects view on object_name and object_type.

Frank van Bortel

Top-posting is one way to shut me up...
Received on Mon Dec 24 2007 - 07:46:34 CST

Original text of this message