is there any implementation of nested tables in SQL ?
i have been told by my teacher that i will have to use nested tables in my project and i am using sql server 2008. i have searched the internet but have failed to find any useful info.. i read in a post in a forum that that concept of nested tables does not exist the way it does in oracle ( that is table within a table) but has the concept of primary and foreign key instead ..
PLEASE TELL ME WHETHER NEST TABLES EXIST IN SQL ?
AND IF SO PLEASE HELP ME WITH THE CONCEPT ...
As an aside, it pains me that colleges are teaching topics like nested tables, a feature added to DBMSs like Oracle purely to tick a box in their "object-relational" feature list and of no practical use to anybody. So every year a mass of students emerge from their colleges thinking nested tables are something you should be using in your databases, and if unchecked no doubt introduce them into their employers' databases. *Sigh*.