Re: How to access Synonym when it has same name as that of a Table
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Mon, 24 Dec 2007 14:46:34 +0100
Message-ID: <3e44c$476fb839$524b5c40$13848@cache5.tilbu1.nb.home.nl>
Date: Mon, 24 Dec 2007 14:46:34 +0100
Message-ID: <3e44c$476fb839$524b5c40$13848@cache5.tilbu1.nb.home.nl>
basab.datta_at_gmail.com 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.
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Mon Dec 24 2007 - 07:46:34 CST