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 -> No foreign key allowed in type?

No foreign key allowed in type?

From: Doug Cowles <dcowles_at_i84.net>
Date: 2000/07/04
Message-ID: <la85ms46puhnu4rfvdr9skiss5gl88rng8@4ax.com>#1/1

We have a many to many join situation, and were thinking of speeding it up by having a varray of types in one of the tables containing all of the join information. However, it doesn't appear that foreign keys are allowed in object types.. Is this correct?

Is there another way arround this?

Specifics

Table A (id number, etc.,)
Table B (id number, etc.,)

Join table

Table C (Aid, Bid)

We'd like to add an object type to A in a varrary that could contain several foreign key references like

create type xyz as object
(a VARCHAR2(30),
 b number, contraint xyz foreign key (b) references B(id);

Any possibilities in the new object-relational world?

Received on Tue Jul 04 2000 - 00:00:00 CDT

Original text of this message

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