Skip to content Skip to sidebar Skip to footer

Retrieving Entries Of Linked List In Relational Database

For my project, I implemented linked list with rdbms. The linked list uses rowid column as a pointer, and contains prior, next and owner pointer(from different table). The simple

Solution 1:

select * from EMPLOYEE
where DEPT_EMPLOYEE_owner = [OWNER_ROWID}
start with OFF_EMP_prior is NULL
connect by OFF_EMP_prior = prior rowid;

Solved the problem with the query above. 'prior' should be used instead of nocycle.


Post a Comment for "Retrieving Entries Of Linked List In Relational Database"