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: Field Order via Oracle ODBC

Re: Field Order via Oracle ODBC

From: TC <a_at_b.c.d>
Date: 9 Jun 99 16:27:32 GMT
Message-ID: <01beb294$fa0e55e0$53fa98cb@pentium>

Brad Pybus <brad_pybus_nospam_at_hotmail.com> wrote in article <%%v73.1733$sk1.2500_at_client.news.psi.net>...
> We never use multi-field primary keys.

But how can you avoid so doing?

In any master/detail relationship, the detail record will normally need a composite primary key, namely:
* the master key of the parent table, plus * the extra field which distinguishes the child records for a given master.

For example:
* Invoice Header -primary key = InvoiceNumber; * Invoice Detail - primary key = (InvoiceNumber, InvoiceLineNumber).

Yes? No?

TC
(No email) Received on Wed Jun 09 1999 - 11:27:32 CDT

Original text of this message

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