Re: correct table design
Posted by: Frank Jonas
Date: September 22, 2006 05:35AM

Hi,

there's a little thing in your last table:

FOREIGN KEY (grp_id2) REFERENCES tbl_product(!!prd_id!!) ON UPDATE CASCADE

Maybe you name the key to product rel_prd, but thats only for better reading.


With that concept you not have any problems.

Best Regards
Frank

Options: ReplyQuote


Subject
Written By
Posted
September 15, 2006 08:41AM
Re: correct table design
September 22, 2006 05:35AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.