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