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>
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 , Germanyemail: mueller_at_informatik.uni-leipzig.de Web: http://www.informatik.uni-leipzig.de/~mueller/ Received on Wed Aug 30 2000 - 15:49:07 CEST