Re: Object Relational Feature

Hello MG,

  Based on what you are describing views is the one way to do it.

  You can customize output of the table data using functions, create a view and let user access it.

Regards,

  Ron
  DBA Infopower
  http://www.dbainfopower.com
  Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html

"MG" <deeplfo_at_yahoo.com> wrote in message news:c8e3e11c.0402051701.7881358e_at_posting.google.com...
> Hi,
> I am interested to know if there are any features in Oracle that would
> allow a design similar to the "design by contract" methodology that
> exists in the OO world. I read about the Object Relational Feature,
> and it seems to be pretty creative, but it's also very limited towards
> any change. What I'm after is something similar to an interface in
> Java, but for tables in Oracle. Can you abstract out the interface to
> a table, i.e. what the client/user can see, from it's actual
> implementation. If such mechanism is in place, are there any
> performance costs that would make it not viable. I'm looking at
> applying this in a data warehouse project. I'd appreciate any
> pointers towards where I can find such information.
>
> Thanks,
> Mohsen
Received on Sun Feb 08 2004 - 12:47:31 CST