Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: REF Datatype

Re: REF Datatype

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 04 Jul 2006 09:25:43 -0700
Message-ID: <1152030347.6709@bubbleator.drizzle.com>


Khurram wrote:
> hi
>
> Thanx Morgan for replying me I wana ask
>
> In general , object type is used to create complex ,user defined
> datatype,we can
> reusable object type in alls apllication consistently,it maintains the
> standard through out
> the application designing and centralized to amend e.g address
> specification could be
> poor implementation without using object type we create address object
> type and then
> distribute in application to standarize the address specification.
>
> The other advantage a developer need to understand the relationship
> between the
> objects type (class) and neednt to understand the realtion between
> tables
> (relational model) which in turn hide the complex queries like joining
> etc.
>
> I wana ask any other advantages of using object type ??
>
> Now my second question Scoped REFs encompasses only that object table
> or ??
>
> My third question why OOPs is not being adopted in ORACLE is there any
> pros-cons or its not mature enough yet?
>
> Khurram
>
>
>
> DA Morgan wrote:

>> Khurram wrote:
>>> hi
>>>
>>> What are  advantages of REF Datatype other then ,Oracle does joins for
>>> you when needed, and in some cases can avoid doing joins.
>>>
>>> Khurram
>> What do you mean by advantage? Better than nothing?
>> --
>> Daniel A. Morgan
>> University of Washington
>> damorgan_at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Group
>> www.psoug.org

  1. DO NOT top post
  2. Tom Kyte recommends using relational tables and relational constraints with object views: I concur. -- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org
Received on Tue Jul 04 2006 - 11:25:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US