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