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);
end;