select object_type from acs_objects where object_id = :folder_id select parent_id from cr_items where item_id = :item_id select count(*) from cr_mime_types where mime_type = :mime_type insert into cr_mime_types (mime_type, file_extension) values (:mime_type, :extension) select item_id from cr_items where parent_id = :parent_id and name = :name select name from fs_folders where folder_id = :folder_id select count(*) from dual where exists (select 1 from fs_folders where folder_id = :object_id) select count(*) from fs_objects where parent_id = :folder_id