Set-valued object attributes in oracle

From: Robert Mueller <mueller_at_informatik.uni-leipzig.de>
Date: Wed, 30 Aug 2000 15:49:07 +0200
Message-ID: <Pine.GSO.4.21.0008301546400.22863-100000_at_lipsia.informatik.uni-leipzig.de>

Hallo,

does "object-relational" oracle in some way supports set-valued component or association objects within a type definition? For example, if I have something like

CREATE EMPLOYEE AS ... can I then define

CREATE DEPARTMENT AS
(Name VARCHAR(30),

 Employees REF(EMPLOYEE) ARRAY[] (or Employees SET(EMPLOYEE))  ...
)

to express the 1:many relationship between a department and its employees?
(This would correspond to the current SQL3 standard of user defined types)

Any comments or pointer are welcome
Thanks
Robert

Dipl. Math. Robert Mueller        Tel.: (+49) 341 97 32227
Institut fuer Informatik          Fax.: (+49) 341 97 32209 (secretary) 
Universitaet Leipzig, Augustusplatz 10/11, 04109 Leipzig , Germany           

email: mueller_at_informatik.uni-leipzig.de Web: http://www.informatik.uni-leipzig.de/~mueller/ Received on Wed Aug 30 2000 - 15:49:07 CEST