oracle
8.1.6
select content_item.move(
:one_item,
:folder_id
)
select
cf.folder_id, cf.label, ci1.level
from cr_folders cf, (select item_id, level from
cr_items
connect by prior item_id=parent_id
start with :root_folder_id
) ci1
where
ci1.item_id=cf.folder_id
and exists (select 1
from acs_object_party_privilege_map m
where m.object_id = cf.folder_id
and m.party_id = :user_id
and m.privilege = 'write')
order by order by ci1.level, cf.label