Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> help! nested table, trigger and OR way
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