View Full Version : Generate 1:n or n:m relation between tables in Oracle
Jamal Larhzal-Gramberg
01-19-2004, 03:20 AM
Hi everybody,
Any suggestion how I can generate 1:n or n:m relation between two tables.
Maybe by Enterprise Manager.
Thanks a lot.
--
---------------------------------------------------------------
Jamal Larhzal-Gramberg
Plath GmbH
Abteilung Systeme
Gotenstraße 18
D-20097 Hamburg
Phone: +49 40 237 34 122
Fax: +49 40 237 34 173
Email: j.lathzal-gramberg@plath.de
http://www.plath.de
---------------------------------------------------------------
Daniel Morgan
01-19-2004, 07:56 AM
Jamal Larhzal-Gramberg wrote:
Hi everybody, Any suggestion how I can generate 1:n or n:m relation between two tables. Maybe by Enterprise Manager. Thanks a lot. -- --------------------------------------------------------------- Jamal Larhzal-Gramberg Plath GmbH Abteilung Systeme Gotenstraße 18 D-20097 Hamburg Phone: +49 40 237 34 122 Fax: +49 40 237 34 173 Email: j.lathzal-gramberg@plath.de http://www.plath.de ---------------------------------------------------------------
What exactly do you mean by your question that can't be restated as:
Build a referntial foreign key relationship?
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)
MyLounge.com Site Map
Forum:
Cars,
Cell Phone,
Database,
Games,
Home Improvement,
IT,
Music,
School,
Sports,
Web Design,
Web Server,
Weight Loss
The MyLounge.com forum is intended for informational use only and should not
be relied upon and is not a substitute for any advice. The information contained
on MyLounge.com are opinions and suggestions of members and is not a representation
of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for
the accuracy, completeness or usefulness of any postings or the qualifications
of any person responding. Please consult a expert or seek the services of an
attorney in your area for more accuracy on your specific situation. Please note
that our forums also serve as mirrors to Usenet newsgroups. Many posts you see
on our forums are made by newsgroup users who may not be members of MyLounge.com
Term of Service
vBulletin v3.0.7, Copyright ©2000-2009, Jelsoft Enterprises Ltd.