everything
Technical User
Hi,
Does anyone has any idea of how to create/imitates object inheritance in Oracle8 since it does not support this feature?
1) Suppose I've created a Person_TY
(name varchar2(50)
gender char(1));
and I want to have student_ty(degree_taken,department) and teacher_ty(field,department) as a subtype of person_ty, what should I do?
2) If a person happened to be a student and teacher at the time,a subtype is created for it. Example:studenteacher_ty. It will of course inherit the attributes of person_ty,student_ty and teacher_ty. However, the attributes(department) are present in both student_ty and teacher_ty, it will then have conflict right? Is there anyway to solve the problem. I thought that changing the attributes might solve this problem ,but if I insist on using the same name for the attributes, what should I do then?cle8?
I do appreciated your help. Thanks
Does anyone has any idea of how to create/imitates object inheritance in Oracle8 since it does not support this feature?
1) Suppose I've created a Person_TY
(name varchar2(50)
gender char(1));
and I want to have student_ty(degree_taken,department) and teacher_ty(field,department) as a subtype of person_ty, what should I do?
2) If a person happened to be a student and teacher at the time,a subtype is created for it. Example:studenteacher_ty. It will of course inherit the attributes of person_ty,student_ty and teacher_ty. However, the attributes(department) are present in both student_ty and teacher_ty, it will then have conflict right? Is there anyway to solve the problem. I thought that changing the attributes might solve this problem ,but if I insist on using the same name for the attributes, what should I do then?cle8?
I do appreciated your help. Thanks
