Re: How will I adapt from Pick to Oracle?

In article <xJbw6.14197$TW.58834_at_tor-nn1.netcom.ca>,  "Albert Kallal" <kallal_at_msn.com> wrote:

>What was one record, now becomes 3 tables, and two of them are
>multi-records. YOU have to work out this relation stuff when doing
>updates. The sql engine might enforce RI for you, but that just stops
>your code from doing something wrong!

And what's even worse is the way SQL databases typically do joins. A big (sometimes HUGE) Cartesian product is formed, and then the rows that don't match are eliminated. So, if you aren't careful, your select can return results that don't really exist in your database.

Ray

-- 
.=================================================================.
| =-=-=-=-=-=-= Eagle Rock Information Systems Corp =-=-=-=-=-=-= |
| -=-=-=-=-=-=- web and database business solutions -=-=-=-=-=-=- |
| <http://www.eaglerock-is.com>    <mailto:info@eaglerock-is.com> |
| Chicago Area Office:  630-955-0365 (voice)  503-905-8153 (eFax) |
.=================================================================.