Re: Oracle and PICK

From: Tony <andrewst_at_onetel.net.uk>
Date: 17 Apr 2004 11:02:27 -0700
Message-ID: <c0e3f26e.0404171002.3c3ae4c2@posting.google.com>

"Nick" <nquinnusa_at_earthlink.net> wrote in message news:<XC8gc.12319$zj3.10639_at_newsread3.news.atl.earthlink.net>...
> Ok,
>
> Define an Order Header and the Order Items in that table, please.

You know that I know that you know that I would now provide you with 2 create table statements. And I know that you know that I know that you would then say that was a Bad Thing. Etc. etc. etc.

All we need then is for Wol to come along and claim that now I have mysteriously "scattered" the 2 entities Order and Order Line across 2 separate tables, there is no way the DBMS can put them together again!

Perhaps it's best that I just don't bother ;-) Received on Sat Apr 17 2004 - 13:02:27 CDT