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

Home -> Community -> Usenet -> c.d.o.server -> Re: not using foreign keys?

Re: not using foreign keys?

From: Mark Harrison <mh_at_pixar.com>
Date: Thu, 26 Jul 2007 21:17:16 GMT
Message-ID: <wb8qi.41345$Um6.9962@newssvr12.news.prodigy.net>


In comp.databases.oracle.misc DA Morgan <damorgan_at_psoug.org> wrote:
> It is really a question of education and we need to educate them about
> those factors we think of as basic starting with the fact that data has
> value.

This is so strange. As a developer I love the idea that there are some consistency guarantees. For example, when looping over a table with FK constraints, I can grab the referred FK row without having to have worry about the error-case that the referred row is not there, saving such tons of code clutter.

But maybe these are the developers that wouldn't check for that anyway. :-/

Cheers,
Mark

-- 
Mark Harrison
Pixar Animation Studios
Received on Thu Jul 26 2007 - 16:17:16 CDT

Original text of this message

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