oracle8.1.6 parent_id in (select item_id from cr_items where content_type = 'content_folder' connect by prior item_id = parent_id start with item_id = :folder_id)