Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: can a field reference the sum of a field in another table?
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 DBAReceived on Fri Jul 30 2004 - 09:28:53 CDT
![]() |
![]() |