This content has been marked as final. Show 1 reply
983198 wrote:If I understand you correctly, simply use the normal 1-to-many icon in the diagrammer. Click within the entity and then click again the same entity: you
I couldn't find this info about Oracle Designer, I'm drawing an Entity relationship diagram to represent a company.
I have to *represent a recursive 1-to-many relationship* (HeadOffice is of type branch and heads all the company Branches).
Is there an appropriate icon to use in the Designer tool or should this be done in SQL later in the process?
Could you give an example??
Thanks and regards,
will get a recursive relationship.