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: multi-valued field?

Re: multi-valued field?

From: Programming <sysdev_at_mb.sympatico.ca>
Date: 1997/01/14
Message-ID: <32DB96DE.4938@mb.sympatico.ca>#1/1

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

Original text of this message

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