oracle8.1.6 select term, definition, revision_id, item_id, name, mime_type, decode(acs_permission.permission_p(item_id, :user_id, 'glossary_term_modify'), 't', 1, 'f', 0) as term_modify_p from glossary_terms_live_definition where item_id = :item_id select title from glossariesx where revision_id = content_item.get_live_revision(:glossary_item_id)