Hi everyone
Im spanish and im searching for help because im having a problem with my database in order to insert some values and i dont know how to solve it.
The thing is i have hierarchy. In the top i have a entity call 'Library' and one Nested Table call 'Room' this entity 'Room' which is is a Nested table from 'Library' is divided in two subclasses 'Comun_Room' and 'Study_Room'. Well i hope it is clear from now. Now i have a class called 'Booking' and it is associated with 'Study Room' which means in the class of 'Booking' i have a reference to the 'Study Room'.
I just want to know how when i insert values into 'Booking' which is the order to reference the 'Study_Room's that i have created in 'Library'.
I have tried this: SELECT REF(s) FROM ROOM s WHERE ID_ROOM=1; (The Id_Room =1 it is because there is a study_room associated with that id).
But its not working.
I dont know if i have explained myself in a good way but im a little desperate and that's why i have writing something here.
Thanks for reading and for the help.
***Moderator action (Timo): moved from SQL Developer to SQL & PL/SQL space.***