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

Home -> Community -> Usenet -> comp.databases.theory -> Re: vehicle to autoparts relationships

Re: vehicle to autoparts relationships

From: Aloha Kakuikanu <aloha.kakuikanu_at_yahoo.com>
Date: 22 Nov 2006 17:52:50 -0800
Message-ID: <1164246770.634341.318130@f16g2000cwb.googlegroups.com>


Aloha Kakuikanu wrote:
> table AssemblyParts:
> assemblyPart# part# partName
> ----------------- ----- -------------
> 1 112 EXTRACTOR ASSEMBLY
> 1 114 EXTRACTOR ASSEMBLY
> 1 194 EXTRACTOR ASSEMBLY
> 1 112 BOLT ASSEMBLY
> 1 114 BOLT ASSEMBLY
> 1 194 BOLT ASSEMBLY
> 1 110 BOLT ASSEMBLY
> 1 116 BOLT ASSEMBLY
Copy and paste typo. This has to be:

table AssemblyParts:
assemblyPart# part# *assembly*Name

-----------------  ----- -------------
1               112    EXTRACTOR ASSEMBLY
1               114    EXTRACTOR ASSEMBLY
1               194    EXTRACTOR ASSEMBLY
*2*              112    BOLT ASSEMBLY
*2*              114    BOLT ASSEMBLY
*2*              194    BOLT ASSEMBLY
*2*              110    BOLT ASSEMBLY
*2*              116    BOLT ASSEMBLY
Received on Wed Nov 22 2006 - 19:52:50 CST

Original text of this message

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