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 -> help! nested table, trigger and OR way

help! nested table, trigger and OR way

From: tom <tka3_at_hotmail.com>
Date: Sat, 27 Mar 1999 22:47:44 -0500
Message-ID: <36FDA660.2D0838E5@hotmail.com>


Hello Everyone:

Question is following. Any help will be appreciated!

1.
With Oracle8, we have 3 ways to approach the problem. One is relational approach. Second is object way. Third is O-R way. So, what is the line between those approaches. It seems much overhead and complex that create everyting as object table and use object ref to link objects relationship.

2.
The nested table is well suited to the master-detail case. The nested table can not have triggers. So, how to use trigger to auto update the total charge(something like that) in master object table.

Thank you very much!

Tom Received on Sat Mar 27 1999 - 21:47:44 CST

Original text of this message

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