Originally posted by sjrowe
Why am I using oo ! Becuase its a final year cwk for my degree or I would be using relational.
That makes sense! Actually, I don't mind the OO types when used as user-defined datatypes (TYPE point IS OBJECT (x NUMBER, y NUMBER) etc.) - though they don't then go far enough in my view, e.g. they don't allow you to constrain the values entered.
But nested tables, well - that's just breaking 1st normal form isn't it?
Anyway, hopefully someone who reads this can show the way..
I eventeually managed to put a nested table inside the course table I had, it contained all the modules for the course and all the students on the course.
But the example we were given didnt actually have a nested table rather a table of references nested inside, but we were told not to implement a nested table of references.
This seems odd because of two things, firstly I could easily recover all from the table or a row of the table by select 8 from course_tab;
which returned all rows and each neted table withing a row.
But when trying to recover the module code i.e
select * from course_tab
simple enough just want everything where the module code ( nested in table) is 1 it wont do it, also I couldnt just use select * from modul_list_t;
module_list_t is just a nested table of modul types or objects.
the other thing is If I dont use refs and do it like that and I cant recover data in that manner it would mean duplicatin the data in their own tables ie module table, student table ( or perhaps person table with student in side with inheritence )
Anyway hope I havent bored u half to death thanks for the help.