Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQL DEVELOPER NESTED TABLE PROBLEM

JosxluMay 21 2020 — edited May 23 2020

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.***

This post has been answered by odie_63 on May 21 2020
Jump to Answer

Comments

Post Details

Added on May 21 2020
19 comments
1,113 views