MySQL Forums
Forum List  »  Views

INSERT with Subtype Supertype
Posted by: enfield spicer
Date: June 07, 2011 10:17AM

I am trying to work out how to write the SQL to handle the INSERT on a db utilizing a Subtype Supertype design.

Using this db design

how can I create a view and maybe a stored procedure(?) to populate BusinessId & UserId when a new Party is created and assigned a PartyType of either B (Business) or U (User).

Edited 1 time(s). Last edit at 06/11/2011 02:15PM by enfield spicer.

Options: ReplyQuote

Written By
INSERT with Subtype Supertype
June 07, 2011 10:17AM

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.