oracle8.1.6 and bookmark_id not in ( select bookmark_id from bm_bookmarks where folder_p = 't' and owner_id = :user_id start with parent_id = :bookmark_id connect by bookmark_id = parent_id ) select /*+INDEX(bm_bookmarks bm_bookmarks_local_title_idx)*/ bookmark_id, local_title, level as indentation from bm_bookmarks where folder_p = 't' and owner_id = :user_id and bookmark_id <> :bookmark_id and parent_id <> :package_id and acs_permission.permission_p(:bookmark_id, :user_id, 'write') = 't' $exclude_folders start with parent_id = :package_id connect by prior bookmark_id = parent_id begin :1 := bookmark.get_root_folder( package_id => :package_id, user_id => :user_id); end; select count(*) from bm_bookmarks where owner_id = :viewed_user_id and folder_p = 't' and acs_permission.permission_p(bookmark_id, :browsing_user_id, 'write') = 't' select count(*) from bm_bookmarks where acs_permission.permission_p(bookmark_id, :browsing_user_id, 'delete') = 'f' start with bookmark_id = :bookmark_id connect by prior bookmark_id = parent_id select bookmark.private_p(:bookmark_id) from dual begin bookmark.update_private_p(:bookmark_id, :private_p); end; begin bookmark.initialize_in_closed_p(:viewed_user_id, :in_closed_p_id, :package_id); end;