Re: Foreign key in Oracle Sql

After a long battle with technology, DA Morgan <damorgan_at_x.washington.edu>, an earthling, wrote:
> Hugo Kornelis wrote:
>> Within the context of databases used as backend to ERP packages, more
>> functionality of the database is irrelevant.
>
> Nonsense. That is absolute nonsense. If one were to agree with your
> statement one would have to also agree with the statement that much
> of the functionality of SAP, PeopleSoft, Siebel, Oracle CRM, and Onyx
> are unnecessary: And they are the industry leaders.

Historically, that is NOT a nonsensical claim.

SAP R/3 would be a meaningful case in point. Due to their need to support Adabas-D, Informix, DB2, Oracle, and some MPE/iX database, they historically had to use an exceedingly thin "lowest common denominator" of database functionality.

No triggers; no foreign keys; no stored procedures; minimal use of 'possibly-intelligent' types (e.g. - date types).

They couldn't depend on having anything more because of the variations between products.

It wasn't until quite recently that R/3 used database joins...

-- 
If this was helpful, <http://svcs.affero.net/rm.php?r=cbbrowne> rate me
http://www3.sympatico.ca/cbbrowne/finances.html
Developmental Psychology
"Schoolyard behavior resembles adult primate behavior because "Ontogeny
Recapitulates Phylogeny" doesn't stop at birth."
-- Mark Miller