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: can a field reference the sum of a field in another table?

Re: can a field reference the sum of a field in another table?

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Fri, 30 Jul 2004 16:28:53 +0200
Message-ID: <2omkg0t45qhk17bkuttsrsmp2lggo963il@4ax.com>


On Fri, 30 Jul 2004 08:09:57 -0500, kaeli <tiny_one_at_NOSPAM.comcast.net> wrote:

>Hey all,
>
>I'd like to make a table with a field that references the sum of another
>field in another table. I know I could use a view for this, but it would be
>more convenient if I could do it right in the table. Is that possible?

If you want to violate normalization rules, and start your route to hell, yes definitely.

--
Sybrand Bakker, Senior Oracle DBA
Received on Fri Jul 30 2004 - 09:28:53 CDT

Original text of this message

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