Re: How to access Synonym when it has same name as that of a Table
Date: Mon, 24 Dec 2007 14:46:34 +0100
> 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.
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Mon Dec 24 2007 - 07:46:34 CST