Re: Views and tables

From: Steve Baldwin <stbaldwin_at_multiservice.com>
Date: Tue, 17 Nov 2009 08:06:32 +1100
Message-ID: <d282b3ab0911161306k41f4aef5q678527574d9aae13_at_mail.gmail.com>

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.

Steve

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
> different?
>
>
> --
> -- Bill Ferguson
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Nov 16 2009 - 15:06:32 CST