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

Home -> Community -> Usenet -> c.d.o.misc -> Re: 1:c - relation in oracle

Re: 1:c - relation in oracle

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 23 Dec 2003 12:18:01 -0000
Message-ID: <3fe8327a$0$9387$ed9e5944@reading.news.pipex.net>


"Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message news:1a75df45.0312230405.42f6e481_at_posting.google.com...
> "Christian Nein" <christian_at_nein.de> wrote:
>
> > can anybody tell me how a 1:c - relation (c is a fixed number, e.g.1:0,
1:1,
> > 1:2, ..., 1:N) can be realized in Oracle?
>
> Er.. since when does the N part in 1:N not mean 1:2? Or 1:1? Or 1:2?
>
> Or did you mean 1:3? Well, N can also be 3. Here ya go. N := 3. Thus 1:N
is now 1:3.
>
> That is why it is called a 1:N relationship.
>
> N can even be c. N := c. Now 1:c is also realised.
>
> Entity relationships are either a 1:N or N:M. Show me one that is not.

You have relationships in your database designs? you lucky, lucky man <g,d&r>

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Tue Dec 23 2003 - 06:18:01 CST

Original text of this message

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