Re: Views and tables
Date: Tue, 17 Nov 2009 08:06:32 +1100
If you *really* need to programatically return data from one table or another while being 'transparent' to an application, there is at least one way to do this. It will have a performance hit compared to fetching directly from a table, and DML is a bit nasty.
If you want to do this, let me know and give us a bit more information regarding your requirements and Oracle version. I can then try to give you a solution.
On Tue, Nov 17, 2009 at 7:55 AM, Bobak, Mark <Mark.Bobak_at_proquest.com> wrote:
> Exactly...or a private synonym called blah that points to a table in another schema.
> -----Original Message-----
> From: Bill Ferguson [mailto:wbfergus_at_gmail.com]
> Sent: Monday, November 16, 2009 3:54 PM
> To: Bobak, Mark
> Cc: stbaldwin_at_multiservice.com; cemail_219_at_hotmail.com; oracle-l_at_freelists.org
> Subject: Re: Views and tables
> Along the lines of:
> select * from blah;
> If you had both a table and a view named blah, how would Oracle know
> which one you wanted to select from, especially if the structures were
> -- Bill Ferguson