| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: multi-valued field?
Kevin is right.
It's essentially impossible to do a SIMPLE
query on fields that would have a number of values in
them. For instance:
Select unique auto_no
from table_x.
Just try to figure out a way to select all the
auto_no if they were placed all beside
each other. It requires lots of work
from the hard drives, and the CPU.
Rodger Lepinsky
ADP Systems Partnership
Winnipeg, Manitoba, Canada
>
> >OWNER
> >=======
> >owner_no PK
> >name
> >address
> >etc.
> >AUTOMOBILES
> >===========
> >auto_no PK
> >owner_no FK reference to OWNER
> >description
> >license_no
> >etc.
> >--
> >Chuck Hamilton
> >chuckh_at_dvol.com
> >This message delivered by electronic sled dogs. WOOF!
Received on Tue Jan 14 1997 - 00:00:00 CST
![]() |
![]() |